Regex Tool question

[PengJia]

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 

[patrick_digan · Accepted 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")

[PengJia]

Thank you very much, it work perfectly.