Find Key Word or Phrase Matches in Text Paragraph Field

Question

Key word and phrase matching.

I have a text field (think paragraphs).

I want to identify matches against a list of key word and phrases.

The key word and phrases can themselves be grouped by Market (Anmials, Cooling...)

The text field may contain no, one, or multiple key word and phrases.

Real world includes 4,000 records with paragraph or multiple paragraphs of text in each record to be searched.  So, I would prefer not to split each record into multiple single world rows etc.

I want to find all the matches and markets for each text record.

help_match_keyphrases.yxzp

DataNath · Answer

Awesome, glad to hear it worked for you @hellyars! No problem, just let me know if you'd like me to look at tweaks etc.

hellyars · Answer

@DataNath  This works.  So SOLVED.  I might have a new related question related to the real world application looking at multiple text fields.

hellyars · Answer

@DataNathLooking good.  I like that you added the word boundary to include only whole words and phrases.  I'm going to try and fit this into the real world workflow.