Searches for one text string in another.
Syntax:
FIND(search:text, source:text {, start:number})
Searches for the search text string in the
source text string,
and returns the number of the character in the source text where the search text begins.
If the search text is not found 0
(zero) is returned.
Use the optional number start to specify the point in the source text where the search should begin.
Note that FIND
is case-sensitive and so an exact match to the search text must be found.
Spaces, including leading and trailing spaces are counted.
The search text string cannot contain wildcards.
Example:
FIND("moon", "The man in the moon")
returns the number 16
.