Extracting a number from a sentence

[rushabh_shah]

Hi Team,

I am looking to extract a number from a string field. Attaching the sample file with the input and desired output.

I tried using the Regex function but unable to get around it. Also, tried the wildcard function used in Excel in the formula node (Replace formula) but in vain.

Please help.

Regards,

Rushabh

[KaneG]

Hi @rushabh_shah,

Try this in the REGEX Tool with Parse as the Output Method: (\d{5,})

It will find any number over 5 digits, set the 5 to about the minimum it will be, so that you don't pick up other numbers...

[rushabh_shah]

It is working but in some cases it is sonverting the last digits (say 4,2,7 as examples) to 0

[KaneG · Accepted solution]

I'll need more information as to when that is happening, maybe an example of the starting data and the finishing data for one line that is not working. 

[rushabh_shah · Accepted solution]

Attaching a sample record. 

can you please check

[KaneG]

That example is working fine on my machine. Make sure that your field is set to a string type with enough characters