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
Solved! Go to Solution.
@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")
Thank you very much, it work perfectly.