Name in English:FIND
Finds the position of a text within another text and returns the position of the character where it was found. It is case sensitive.
FIND (search_text, within_text, [start_num])
- search_text (required ): The text to be found.
- within_the_text (required ): The text string to search for.
- start_num (optional ): The character number where the search starts. If it is omitted then the search will start from the first character.
FIND (“o”, “hello”) = 2
FIND (“h”, “hello”) = 1