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
15 - Aurora

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

Labels