join tables based on a substring (whole word as part of a string)
dear members of the community,
i have 2 tables. one containing strings and another containing a list of words and numbers.
i would like to join the table based on whether the string includes the exact word. but not if it pat of another (longer) word.
for example 'cat' should match only 'cat' and not 'bigcat' as in the image below.
i have added spaces before and after the terms in order to facilitate....
