Hey guys, I have two tables - one with list of names and another one with some strings like this: Tom has a cat John has a dog Anna has a parrot Frank has a dog Anna has a cow John has a tiger Tom AB has a tiger Tom A41 has a lion Tom B12 has a dolphin Tom 2 has a horse Tom-32 has a dog And I want to count occurrence of each name (that exists in the table with list of names) in table with strings, however it shouldn't count name "Tom" when there is a string "AB" or any number or "Ax" or "Bx" (where "x" is a number) after the name So the result should be: Tom 1 John 2 Frank 1 Anna 2 I know how to count number of names (using for example findw) but I have no idea how to exclude from counting name "Tom" with conditions I've written above. Any guidance will be greatly appreciated.
... View more