Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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