Search for Keywords in a column

Question

Afternoon Team,

Hoping you can help , or point me in the right direction

This question is regarding a workflow that will allow me to search for keywords within a name column.

For this example, the purpose will be to search famous science quotes for a select group of keywords.

In my Raw input File i have the following 2 columns ;

IDName

Example Input

IDName001f100001Inn9NAAR401K Mason0013a00001k5p1iAAAInsurance LTD001f100001OiuyrAABPension Plan.

Step 1 - i would like to have a reference file / table which contains key words

Keyword401kPensionLifeScience

Step 2 - i would then like to search for these words in the reference file / table against the Name in the Input file

Step 3 - Outcome column to indicate where we matched and if possible the weighting of percentage we matched on

IDNameOutcome 001f100001Inn9NAAR401K MasonMatch0013a00001k5p1iAAAInsurance LTDNo Match001f100001OiuyrAABPension Plan.Match

I feel that i we should use the Multi-Field Formula tool to change all words in both the text strings and keywords to uppercase and maybe include the the Use the RegEx

Looking forward to your help

Regards

DevDingreja · Answer

Hi Mason, this is great by any chance do you know of a way to also highlight or identify the keywords?

we currently do this manually and are dealing with huge amounts of data about 20k line items and 300 keywords, each line item sometimes has a summary of about 500 to 600 words.

as of today, we do this via excel using the =COUNTIF(TextH:H, C3) where C3 would be the keyword e.g. *God*

Qiu · Answer

@Masond3 
Tried a different approach if Find and Replace is not your favorite😁

I also considered the case that more than 1 keywords are matched.

I

1106-Masond3.yxmd

Christine_Assaad · Answer

Hi @Masond3

Check this out and see if it will do the trick for you. Cheers!

Find and replace_key words.yxmd