 Formula Engine Reference Guide |
|
Back to Class Index
FIND(S1, S2, N)
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 - FIND, substring not found
where V1 = "Built-in" and V2 = "Functions"