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.


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