Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Reg ex error

Sa743liz-
8 - Asteroid

Done

 

 

 

5 REPLIES 5
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

@Sa743liz- 
RegEx:
^[^\d(]+([\d,.()]+).*$

BS_THE_ANALYST_0-1677527732009.png

It will allow decimals, the brackets, and commas within the number

 

All the best,
BS

LinkedIN

Bulien
Sa743liz-
8 - Asteroid

It shows me a parse error 

 

 

BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

.

 

 

All the best,
BS

LinkedIN

Bulien
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

@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:

BS_THE_ANALYST_0-1677528767559.png

RegEx:
^.*?([\(\d]+[\d,.)]+).*$

 

It seems to behave as expected in Alteryx:

BS_THE_ANALYST_1-1677528851174.png

 

 

 

All the best,
BS

LinkedIN

Bulien
Sa743liz-
8 - Asteroid

Thank you so much that works. 

 

Labels
Top Solution Authors