Question on specific and standalone key word match

Question

Hi,

I am new to alteryx and have a question when trying to do some key word matches ("contains" function in "filter" tool).

Basically, i am going to find records that contains "gene"--- this specific and standalone word in the column [study title], but i don't want to find records that contains degeneration, general, etc. ---the words that has "gene" in it.

My current function is contains([study title], "gene"), wonder how should i refine / adjust it?

Appreciated your help!

JosephSerpis · Accepted Answer

Hi @apoptoticbody if you want to find an exact word the Find and Replace tool might be a tool to consider. I have mocked up a workflow to show how this would work. Let me know what you think?