We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Using a field name within REGEX formula

DominiqueCap
5 - Atom

Hi

 

Is there a way to reference a field within a regex parse?

 

I would like be able to regex parse based on value within a column. 

 

eg: using \b[Keyword]\b

 

String                                                                      Keyword       Expected output
The quick brown fox jumps over the lazy dog        dog               dog
The quick brown fox jumps over the lazy dog        jump             Null

 

Is this possible?

Thanks

2 REPLIES 2
dwstada
11 - Bolide

Hey @DominiqueCap , I don't know if this is possible, but here is a solution that should work as well, using contains() after modifying the inputs a bit

 

DominiqueCap.PNG

Raj
16 - Nebula

@DominiqueCap 
one way of doing this mark done if solved.

Labels
Top Solution Authors