community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

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

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

 

 

Pulsar
Pulsar

Hey @Peter2007 

 

Try using this expression in a Formula tool:

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

Hope this helps!

Highlighted
Fireball

Hi @Peter2007,

 

The following Regular Expression should be what you want.

\D+

Capture.PNG

Sam :)

Labels