Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
Top Solution Authors