community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Regex Tool question

Atom

Hello Alteryx User,

 

I would like to parse out the number 50 from "P14 - XFR CLAIM FROM PATIENT TYPE 50" or parse out the number 40 from "D70 - XFR CLAIM FROM PATIENT TYPE 40"  what is the expression for that?

 

thank you 

@PengJia  A formula like this seems to work on your test data (assuming you want digits at the end of the string)

REGEX_Replace([Field1],".*?(\d+)$","$1")
Atom

Thank you very much, it work perfectly.

 

 

Labels