Hi,
I need to search the content of [Field A] for the value of another field [Keyword Field]. However, the hit of the following pattern should be my positive results:
1. " " + [Keyword Field] + " "
2. " " + [Keyword Field] + "."
3. " " + [Keyword Field] + ","
4. " " + [Keyword Field] + end of line
5. Start of line + [Keyword Field] + " "
6. Start of line + [Keyword Field] + "."
7. Start of line + [Keyword Field] + ","
8. Start of line + [Keyword Field] + end of line
Instead of writing Contains statement in each of those cases, is there any more efficient way to do the search by using other function, such as regular expression.
