REGEX_Match, True/False If a Field does not contains number

[Inactive User]

Hi All,

i want to use REGEX_Match to identify a field does not contain number

e.g.

column name(string)           Result               

112233                                 False

A-211                                   False

21#BCQ                               False

Ticket #                                True

None                                    True

thank you

[Kenda · Accepted solution]

Hey @Inactive User 

Try using this expression in a Formula tool:

iif(REGEX_Match([column name],"(.*)?\d(.*)?")=-1,"False","True")

Hope this helps!

[SamDesk]

Hi @Inactive User,

The following Regular Expression should be what you want.

\D+

Sam :)

[davidhenington]

So awesome you had this queued up and ready to go Kenda! Works perfectly! 

[MelissaV]

It helped me!! Thanks 😉