Find & Count keywords from inside a paragraph of text

Hi all.

I’ve create a simple list of keywords in a table with a single column.

The aim of the project is to have a table where I can input as much text as I want into a row and see which keywords are contained in that text and the total number of keywords in that text.

I have another table that contains three columns - #1. Text // #2. Number of Keywords in Text // #3. Keywords in Text

I am unable to figure out how to write the formula to aggregate and count outputs #2 and #3.

Here is the working example.

Thanks in advance for any guidance,
Nat

Here’s one solution but there’s probably a “cleaner” one!

2 Likes

Great job @Nick_Milner :trophy:, thanks giving me the chance to learn something new :handshake:

1 Like

@Nick_Milner thanks so much for figuring this out! I would have never been able to do this and I definitely learned something new here.

I am truly grateful and humbled by your help.

Thanks so much!
Nat

@Nathaniel_Daudrich

Keywords.Filter(thisRow.Text.Find(CurrentValue.Keyword)!=-1) formula on your Text table would work bit better performance wise

1 Like

Told you there was a better way to do it. :slight_smile:

Hi Krunal,

Thanks for putting that together - your formula is incredibly simple.

:+1:
Nat