Regex Match No Space Only Numbers

[slckkrky]

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 you

[Thableaus · Accepted solution]

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,