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
Solved! Go to Solution.
Sorry, just saw you didnt need always the number in the middle
Try this:
Cheers!
TerryT
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.
Should've shared the RegEx Parse solution:
Cheers!
TerryT