|
Extracts
a portion of a given string.
SyntaxSubstr(s1, n1, n2 )
Parameters
Parameter
|
Description
|
|---|
s1
|
The source string.
|
n1
|
The position in string s1 to
start extracting.
If n1 is less than one,
the function assumes the first character position. If n1 is
greater than length of s1, the function assumes
the last character position.
|
n2
|
The number of characters to extract.
If n2 is
less than or equal to 0, FormCalc returns an empty string. If n1 + n2 is
greater than the length of s1, the function returns
the substring starting at position n1 to the end
of s1.
|
ExamplesThe
following expressions are examples that use the Substr function:
Expression
|
Returns
|
|---|
Substr("ABCDEFG", 3, 4)
|
CDEF
|
Substr(3214, 2, 1)
|
2
|
Substr(Last_Name[0], 1, 3)
|
Returns the first three characters from
the first occurrence of Last_Name.
|
Substr("ABCDEFG", 5, 0)
|
""
|
Substr("21 Waterloo St.", 4, 5)
|
Water
|
|
|
|
