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

Using a Regex Match for specifc characters

R_L
7 - Meteor

Hello,

 

I'm trying to write a condition for a Regex Match.

The string comes in the following format: 12345 AND 123456.

If there is a match for the above, i.e. /d* AND /d*

I want it to generate in another field, the text, "Match".

 

I've tried the following, but no joy:

if REGEX_Match([Field1], "[(\d*\sAND\s\d*)]") then "Match" else "No Match" endif

 

Any help please?

1 REPLY 1
mattreynolds
9 - Comet

Just need to remove the brackets in the Regex: 

 

if REGEX_Match([Field1], "\d*\sAND\s\d*") then "Match" else "No Match" endif

 

Example workflow is attached. Hope this helps!

Labels