FIND

Returns the position of a text within another text.

Syntax

FIND(text; findText)

  • text - the text in which to search for findText - Value type: text

  • findText - the text which is to be found in parameter text - Value type: text

Returns the position of the first occurance of findText within text.

Remarks

  • The search is performed case-sensitive, so the found text within parameter text must have the same casing than parameter findText.

  • If findText is not found, 0 is returned.

Examples