I'm hoping some expert on Regex in Alteryx will see this and tell me what I'm doing wrong.
I cannot figure out how to make Alteryx parse out strings I'm asking of it. I can do this easily in other tools, but it appears Alteryx is using non-greedy matching (i.e. taking the minimum number of characters to match a string) even when I don't specify it.
Consider the string "0 YR/2052 2,800,000.00"
Using the Regex tool in Parse mode, this: .*((\d{1,3},)*\d{1,3}\.\d\d).* returns only "0.00" which are the minimum number of characters needed to match the regular expression. The exact same expression in other tools, including online Regex parsers, returns the expected "2,800,000.00"
Example of it working here: regexr.com/7cli2
The problem I'm trying to solve is a field with bogus data mixed with numbers I want. I need the "\d\.\d\d" at the end of the string to be required because all valid numbers always have at least 0.01 and any number with two decimals up to 1 billion is valid. Part of the bogus data could be numbers, so I can't use RegexReplace() to get rid of all non-numbers, I have to find matching strings without spaces and with decimals that are properly formatted as a number with thousands separators.
