Regex Match No Space Only Numbers

Question

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 Answer

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,