Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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