Alteryx Designer Desktop Discussions

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

Looking for a specific word from a sentence

Manohar12345
5 - Atom

Hi,

I am new to Alteryx and currently facing an issue. 

I have list of key words and I want to flag off that sentence if the sentence contains that word.

But the issue is it not only flags of the 

Ex: Key word - MAT

Sentence 1- MEETING SCHEDULE WITH MAT AT 10 AM

Sentence 2- ACCOUNTS NEED TO BE AMALGAMATED 

1 REPLY 1
benakesh
12 - Quasar

@Manohar12345 

Do you want to match first  record and not the second  ?   

contains([Field1],'MAT')    : matches both 

contains([Field1],' MAT ')   or  REGEX_Match([Field1], '.*( MAT ).*') : matches first 

 

benakesh_0-1573926368886.png

 

Labels