Using ReGex_Match to find multiple words, stream lined formula?

[LAS1]

Hello Alteryx

I am using the Regex formula below to search for specific words in a column (Example the word Armor), The downside is im looking for about 100 different individual words. Is there an efficient way to use the formula below, or do I need to replace the word Armor with the new word 100 different times?

IF (REGEX_Match([Title], ".*\<Armor\>.*")) then 2

ELSE 0

ENDIF

Hope this helps.

Giuseppe

[atcodedog05 · Accepted solution]

Hi @LAS1 

You can find and replace for this scenario. Here is how you can do it.

Workflow:

Hope this helps : )