Searching a text field for words contained in another text field
I would like to create a text analysis program. The basic elements of this solution are a text field, and a single field with either repeated fields or a return delimited list that contain multiple searchstring targets.
So, the text string "i would rather do mine myself" would be searched for the elements in a global (or globally related) field called "first_person_pronouns" that contains "i" "me" "mine" and "myself". And the variable "thisdudesnumberoffirstpersonpronouns" would equal 3 for the subject who wrote the text string.
I tried patterncount but it would only search on the first repetition in a repeating searchstring field.