Find
Finds the first instance of a string within another string. To do a more complex search, such as looking for a string that matches a pattern, use theFind Pattern function instead.
Input Fields
-
look in is the text you want to search inside.
-
look for is the text you want to search for.
Output Fields
- position is the position of the first match, where 0 is the first position. Returns -1 if it is not found.
Examples
If look in is “This is a test”:
-
If look for is “T” then position is 0 (first position, where counting starts with 0).
-
If look for is “test” then position is 10 (11th position).
-
If look for is “hello” then position is -1 (no instance found).