SEARCH

Get the position of a string within a text. SEARCH() is not case sensitive.

Parameter List

Syntax
SEARCH(search_keytext
[start]
)
search_key

The string to look for within the text string. For example: "shuttle".

text

The string in which to search for the search_key string. For example: "SpaceX shuttle".

[optional] start

The character within text at which to start the search. For example: 5. By default it starts at 1.

Examples

SEARCH("super", "Do you really think superman is super fast?") returns 25, as the first instance of "super" starts at character 25.