indexof
Syntax:
Value
Integer
indexof
(
String
str,
String
substr)
Description:
Returns the position of the first occurence of
substr
in
str
or -1 if it is not present.
Examples:
($c1:$c5) = indexof($a, $b)
Before:
A
B
C
1
Hello World
Wo
2
My Name is Alex
Name
3
ABCabc
c
4
4.56
7
5
XSheet
sheet
6
16
After:
A
B
C
1
Hello World
Wo
6
2
My Name is Alex
Name
3
3
ABCabc
c
5
4
4.56
7
-1
5
XSheet
sheet
-1
6
16
($d1:$d10) = indexof($b, "2")