Find Key Word or Phrase Matches in Text Paragraph Field

[hellyars]

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.

[DataNath]

How does this look @hellyars? Went for a batch macro approach which will process the records one key word at a time, checking each row for at least one presence and then counting the number of matches across them all. Outside the macro it then joins the key word back to the market and shows the overall total:

EDIT: Just reread the bottom line of your requirement. If you don't want to aggregate you can just remove the summarise and keep on top of which records are which with an ID which then gets sorted at the end (also filters out 0 matches):

[hellyars]

@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. 

[hellyars]

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

[DataNath]

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.