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

Search a cell to see if it contains a specific string [TRUE/FALSE]

The_Fray
8 - Asteroid

Hello,

 

I am trying to figure out the easiest way to determine whether a cell has a specific string of letters (case insensitive).

 

For example, in the following table, I want to know if the string "leader" is contained in the phrase cell. So it needs to pick up variations like "Leadership", "Leader", 'leader'.

 

The_Fray_0-1583954474034.png

How would I go about doing that? All I need is a True or False output. 

 

Thanks,

 

Frazer

 

2 REPLIES 2
kylemhabe
8 - Asteroid

Try this:

 

kylemhabe_0-1583955374146.png

 

kylemhabe_1-1583955388476.png

 

 

Eswaran
8 - Asteroid

It does not works now.. Can you provide me sample workflow?

 

Labels