In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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