Returns starting position of a substring in a string.
||The string to be searched for substring. An expression that resolves to a string or a numeric value.
||An expression that resolves to a substring to locate within string.
||An expression that resolves to a positive integer specifying which occurrence of substring to locate.
function returns the starting character position, counting from 1, of substring
. Matching of substring
is case-sensitive. You use the occurs
argument to specify which occurrence of substring
to return the location of.
returns 0 for any of the following:
is a mixed numeric string, the numeric part is parsed until a non-numeric character is encountered. Thus 7dwarves is parsed as 7.