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 the Find 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).