Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to search for a string, but avoid matches where string is part of a word?

csh8428
11 - Bolide

I'm trying to figure out how to search a free-form text field for a specific string, but I need to be able to avoid matches if that string is part of a word.

 

For example, I want to return only records where field [Comment] has "uat" all by itself somewhere in the text field. If I use a CONTAINS([Comment],"uat") in a filter it will also show true for records that have words with "uat" inside them like "situation". I do NOT want results where the search team is part of a word. I only want results where the search term exists by itself.

 

Put more simply:

YES: "I went to uat street"

NO: "The situation was nice"

 

Thanks for any help!

 

Craig

 

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux

A few options for this - I'd look at this article which has a similar question and answer: Re: Text Mining Alternative for Contains - Alteryx Community

MilindG
12 - Quasar

@csh8428 Find replace tool works for you?

aatalai
15 - Aurora

If you have the intellegence suite you can use the pre cleanese

HomesickSurfer
12 - Quasar

Hi @csh8428 

I support @MilindG 's approach to use the Find Replace Tool and Match Whole Word Only.

 

Capture.PNG

Labels
Top Solution Authors