A-61635 December 2010 4-33
Examples
[5]
Description — get sub-string from the 5
th
character to the end of the original
value.
“ABCDEFGHIJKL” Î “EFGHIJKL”
“1234567890” Î “567890”
“1234” Î “”
[*]
Description — get full string
“ABCEDFG” Î “ABCDEFG”
“1234567” Î “1234567”
[start, end] — used to extract a sub-string starting at the position start and
ending at the position end of the original value.
• If end is a positive number, the end position will be counted from the
beginning of the original value.
• If end is a negative number, the end position will be counted from the end of
the original value.
• If end is 0 or *, the end position will be the end the original value.
• If the start position is after the end position, the sub-string will have the
reverse order of the original value.
Examples
[1, 2]
Description — get sub-string from the 1
st
character to the 2
nd
character of the
original value.
“ABCDEFG” Î “AB”
“123456” Î “12”
[-4, -1]
Description — get sub-string from the 4
th
from the last character to the last
character of the original value.
“ABCDEFGHIJK” Î “HIJK”
“1234567890” Î “7890”
[*, 5]
Description — get sub-string from the 1
st
character to the 5
th
character of the
original value.
“ABCDEFGHIJK” Î “ABCDE”
[5,2]
Description — get sub-string from the 5
th
to the 2
nd
character in reverse order
of the original value.
“ABCDEFGHIJK” Î “EDCB”
“1234567890” Î “5432”
To Next Page
Loading...