Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need to Extract Number

prasadsra9
5 - Atom

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 

 

 

6 REPLIES 6
afv2688
16 - Nebula
16 - Nebula

Hello @prasadsra9 ,

 

This may help you

 

Sin título.png

 

Regards

afv2688
16 - Nebula
16 - Nebula

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

TerryT
Alteryx Alumni (Retired)

Try this:

TerryT_0-1579114851805.png

Cheers!

 

TerryT

afv2688
16 - Nebula
16 - Nebula

Corrected 🙂

 

Sin título.png

prasadsra9
5 - Atom

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
Alteryx Alumni (Retired)

Should've shared the RegEx Parse solution:

 

TerryT_0-1579192612700.png

 

Cheers!

 

TerryT

Labels