Find & Count keywords from inside a paragraph of text

1

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

2

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

2 Likes
3

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

1 Like
4

@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

5

@Nathaniel_Daudrich

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

2 Likes
6

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

7

Hi Krunal,

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

:+1:
Nat