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