Need to Extract Number

[prasadsra9]

Need to Extract a number from a string below is the input and need the Output as mentioned in this example  

Input  = SUB 12356 PO 65987568 //   Output =  12356

Input  = PO 65987568 SUB 12356 //   Output =  12356

Input  = PO 65987568 SUB for 123567 // Output =  123567

Input  = Sub for 12356; po 58965239 // Output  = 123456

Input  = SUB for 12356; po 58965239 // Output  = 123456 

[afv2688]

Hello @prasadsra9 ,

This may help you

Regards

[afv2688]

Sorry, just saw you didnt need always the number in the middle

[TerryT]

Try this:

Cheers!

TerryT

[afv2688 · Accepted solution]

Corrected 🙂

[prasadsra9]

Hi,  this works, but if i have in the filed only a sting like "Purchase Order",  in the output the same string is shown, but I need to ignore it.

[TerryT]

Should've shared the RegEx Parse solution:

Cheers!

TerryT