Data Extraction from a String column

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.

Regex

Accepted answers

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.

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.

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

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