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.
Solved! Go to Solution.
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.