Finding an exact match in an excel file

[srea541]

I currently have a workflow which uses the contains() function to search through a column:

The issue I am having is I only want to find the exact words specified in my excel input, but contains() will return a positive result even if a word happens to be within a word in my input file e.g. if i want to search for "hug", the workflow returns a positive value whenever it finds the word "huge"; but I only want to see a positive result if the exact word is found.

Any ideas?

[atcodedog05 · Accepted solution]

Hi @srea541 

Give my previous response in this post a try.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Formatting-cell-colour-if-it-contains-... 

I am using find and replace which has the match word option. If it doesn't work let me know.

Hope this helps : )

[srea541]

Thank you so much! Sorry I didnt see that yesterday lol

[atcodedog05]

Happy to help : ) @srea541 

Cheers and have a nice day!