This function returns the offset of a string or character and ends the search when any of the conditions are met. If the search does not reveal a match, -1 is returned. This works in both value field formulas and row rules.
Parameters: source string, string (for a character search) OR source string, substring, substring (for a substring search)
This example searches for the first occurrence of '=', ';' or ' ' in a string and returns the offset when the first of those is found. The character count for the string starts at 0.
This example searches for the first occurrence of the strings "X:", "Y:", "End" or "Start" and returns the offset when the first of those is found. Note that the search for the strings is case-sensitive, so it will not find instances of "x:", "y:", "end" or "start".