SCANSTR Function
The SCANSTR function evaluates the position of one string value (substring) within another string value (text). Use this function to extract a specific portion of an existing string, or to evaluate if text exists within the specified string.
Syntax
SCANSTR(substring, text)
Example 1
SCANSTR("Ontario","Toronto, Ontario")
Returns a value of 10, the start position of the string value specified within the larger string.
Example 2
SCANSTR("Alberta","Toronto, Ontario")
Returns a value of 0, since the string value specified does not exist in the larger string.