In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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