Hi,
I want to search a longer text field for a shorter string that may be within it. However, I want to do this for multiple short strings.
For instance:
Phrase Hidden word
Please search the text for the hidden message: Blue
The hidden word, Green, may be at any point
And the word may be different lengths like Yellow
I have a table of the hidden words (Blue, Green, Yellow, Pink)
I know I could use search to find one word, but is there a way to look for multiple words, and return the value of which one it finds? I have many hidden words (and the list is dynamic) so I don't want to just split into multiple searches.
Thanks in advance!!
Bookmarks