ok now.
Two things:
1. Based on upper example separators between words are / . and ?
Can there be any more separators like =
2. If you separate words such way then it will return first matchin criteria.
For example, if in D column you have:
Then when you separate text: tree/bell/makushi/train/tree/bell/makushi/train/
Into words and try to match D column it will return: John climb on the tree
because word tree is first of checking words and there is no any reason why check makushi and not check tree so I must check them all.
If this is something that you don't want to then you can define one more column with just matching words.
For example like this:
That will match criteria word and return text next to it.
So tree/bell/makushi/train/tree/bell/makushi/train/
Will return : is Makhushi a good boy
Because tree is not matching word.
Is this make sense?
Bookmarks