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 c…

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

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

@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

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

Find & Count keywords from inside a paragraph of text

Nick_Milner June 14, 2019, 8:17pm 6

Told you there was a better way to do it.

Document full of tables...can I compare 1 table to all others to find matches?

How to count repetitions of words in text

Topic		Replies	Views
How to count repetitions of words in text	1	797	June 17, 2019
Counting the number of times a word appears in a list	14	3074	August 20, 2022
Count Words Used in text	4	575	March 3, 2023
How to count the number of times a word is in a table?	4	591	December 19, 2022
Search Keywords in Column & Add as List with multipleselection	2	513	October 22, 2019

Find & Count keywords from inside a paragraph of text

Related topics