@Sa743liz-
RegEx:
^[^\d(]+([\d,.()]+).*$
It will allow decimals, the brackets, and commas within the number
It shows me a parse error
@Sa743liz- that's actually a little more complex than I originally spotted. You actually have brackets before the numbers sometimes. I think this is actually doing what we want here:
RegEx:
^.*?([\(\d]+[\d,.)]+).*$
It seems to behave as expected in Alteryx:
Thank you so much that works.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |