Extract order numbers

[Silviu_Albisoru]

Hi all. I need your help. I have a text extracted from the name of a file and it is of the form: 1000000_client name_4600000_49000000_180000000. The first number represents the customer id and the rest of the numbers represent the orders. The latter are dynamic like numbers. That is, there can be three order numbers or there can be fewer or more, depending on the case. How do I manage to extract them individually? I would be interested in an expression so that I can use it in the Matches activity. Thank you in advance!

[Anil_G]

@Silviu_Albisoru

You can use \d+ …they are only numbers so this should work

Cheers

[ppr (Peter)]

@Anil_G

You can use \d+ …they are only numbers so this should work

@Silviu_Albisoru
we can anchor on the underscore like:

[Silviu_Albisoru]

Thank you all!