Is it possible to write an IF statement that looks at a string of text, and will perform an action if the string CONTAINS a certain word e.g. IF this statement in Field 1 contains the word “dog”, write “dog”, otherwise, write nothing.
I went to the pet store and I bought some dog food.
Searches for an occurrence of the text string (search text) within another string (text) and returns the starting position of any matching occurrence. The first character in the text is position 0. A return position of -1 indicates that search text was not found.