If there aren't any punctuation in the original text, you could start with a calculation like this:
t = YourTextField ;
r = YourRepeatingTextField ;
adj_t = Substitute ( t ; " " ; ¶ ) ;
adj_r = List ( r )
ValueCount ( FilterValues ( adj_t ; adj_r ) )
Thanks for that. I see the logic of what you are suggesting:
adj_t turns the space separated words in the user's text to carriage returns creating a big long list. adj_r turns the repeating fiels with teh search terms into a list, and then the valuecount counts the number of words in the users list that appear on the search list.
I pasted this exactly into a calculation, and carefully substituted my text and search fields and it returns a value of 0.
Could you copy & paste here your calculation ?