Row/String contains atleast 1 digit then true

[wonka1234]

hi,

How can I make a formula that will return true if a string has atleast a digit?

REGEX_MATCH([col],'\d*')  , doesnt seem to work.

Thanks.

[BrandonB · Accepted solution]

Try this:

REGEX_Match([Field1], ".*\d+.*")

[BrandonB]

That means zero or more of any character followed by one or more digits followed by zero or more of any character

[Mchappell67]

Hi, @BrandonB -

Would REGEX_Match([Field1], "\d+") be equivalent to what you posted?

Thanks,

Mark

[BrandonB]

Hi @Mchappell67 

It is close, but it doesn't account for characters before and after the digit. REGEX_Match is looking for a specific pattern so if you have it looking for just one or more digits, it isn't accounting for what is before or afterwards. Your solution would work if it was a cell with only digits.