FIND(S1, S2, N)

 

Description

This function returns the index of the first occurrence of string S1 in string S2, starting the search at position N in string S2.  Note that the string index always starts with 0.

 

Parameters

 

S1

A string value.

 

S2

A string value.

 

N

A numeric value.

 

Examples

 

FIND("bc", "abcdefg", 0) = 1

 

FIND(V1, V2, 5) = 9

Where V1 = "Functions", and V2 = "Built-in Functions".

 

FIND(V1, V2, 5) = #Error

Substring not found, where V1 = "Built-in" and V2 = "Functions".