Alteryx Designer Desktop Discussions

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

Finding an exact match in an excel file

srea541
8 - Asteroid

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

srea541_0-1632495632160.png

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?

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

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
8 - Asteroid

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

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @srea541 

Cheers and have a nice day!

Labels
Top Solution Authors