Data Extraction from a String column

[Pranab_C]

Hello Alteryx Experts,

I need help in extracting values from a column which has text and number, I need to extract 100,893 and 473461 from the following two lines.

Total tax $ 100,893

Wages , salaries , tips, etc. Attach Form(s) W-2 1 473,461.

[gawa · Accepted solution]

@Pranab_C 

Simple Regex tool can help. Regex here is (\d+,\d+|\d{2,3})

It matches "two or three digits number" OR "more than 4 digits with comma separator for thousands".

Try this as first attempt to know this will do for the rest of your data.

[Pranab_C]

Wow, thank you so much that worked like a charm.

[Pranab_C]

Just a follow-up a question, however the Regex fails in these situations.