I have a list of about 400 keywords Im looking for from a free form text field. What I am trying to accomplish is to find the number of occurrences of keywords from the list of keywords in the txt field where i have many paragraphs of text.
I have one field where I have all the keywords stored, all lower case
Another field where I have free form text, all lower case.
I am trying to see how many times keywords from the list come up as pattern matches from the text field of free form text.
here is a short list words im looking for :
and the text field has "bob went to the store, then bob went home."
I would like a 3rd field to say:
bob came up 3 times
went came up 2 times
store came up 1 times
Ive attached an example file. Thanks for any help you can give:)