Alteryx Designer Desktop Discussions

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

Regex Match No Space Only Numbers

slckkrky
8 - Asteroid

Hi

 

I am trying to capture records that contain only number and no space anywhere in the record. I am using REGEX_Match([Field1], '^\d.\s*') in my test input and it works as I desire (Column Regex).

However when I use same formula in my real data set (same data type as test dataset), it doesnot work properly.

Any idea what would cause that?

 

Thank youCapture5.PNG

1 REPLY 1
Thableaus
17 - Castor
17 - Castor

Hi @slckkrky 

 

I think the ideal regex in this case would be

 

REGEX_Match([Field1], '\d+')

 

If you only want numbers in the record.

 

Cheers,

 

 

Labels
Top Solution Authors