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

[csh8428]

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

[alexnajm]

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 · Accepted solution]

@csh8428 Find replace tool works for you?

[aatalai]

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

[HomesickSurfer]

Hi @csh8428 

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