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

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-a-text-value-defined-in-an/m-p/825880#M202132 

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

Hope this helps : )