substring
Syntax:
Value
String
indexof
(
String
str,
Integer
start,
Integer
end)
Description:
Returns a substring of
str
that starts at character number
start
and ends before character number
end
.
Examples:
($a1:$a5) = substring($self, $b, $c)
Before:
A
B
C
1
Hello World
6
8
2
My Name is Alex
0
5
3
ABCabc
3
10
4
4.56
7
10
5
XSheet
3
2
6
16
After:
A
B
C
1
Wo
6
8
2
My Na
0
5
3
abc
3
10
4
7
10
5
h
3
2
6
16
($d1:$d10) = substring($b, 0, 1)