Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Inactive User
Not applicable

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

 

 

4 REPLIES 4
Kenda
16 - Nebula
16 - Nebula

Hey @Inactive User 

 

Try using this expression in a Formula tool:

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

Hope this helps!

SamDesk
11 - Bolide

Hi @Inactive User,

 

The following Regular Expression should be what you want.

\D+

Capture.PNG

Sam :)

davidhenington
10 - Fireball

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

MelissaV
5 - Atom

It helped me!! Thanks 😉

Labels