The StringHandling routines allow you to carry out various kinds of operations and tests on alphanumeric expressions, based on Java methods.
To access these routines, doubleclick on StringHandling under the system folder. The StringHandling class includes the following routines:
Routine |
Description |
Syntax |
---|---|---|
ALPHA |
checks whether the expression is arranged in alphabetical order. Returns the true or false boolean accordingly. |
|
IS_ALPHA |
checks whether the expression contains alphabetical characters only, or otherwise. Returns the true or false boolean accordingly. |
|
CHANGE |
replaces an element of a string with a defined replacement element and returns the new string. |
|
COUNT |
Returns the number of times a substring occurs within a string. |
|
DOWNCASE |
converts all uppercase letters in an expression into lowercase and returns the new string. |
|
UPCASE |
converts all lowercase letters in an expression into uppercase and returns the new string. |
|
DQUOTE |
encloses an expression in double quotation marks. |
|
INDEX |
returns the position of the first character in a specified substring,
within a whole string. If the substring specified does not exist in the
whole string, the value |
|
LEFT |
specifies a substring which corresponds to the first n characters in a string. |
|
RIGHT |
specifies a substring which corresponds to the last n characters in a string. |
|
LEN |
calculates the length of a string. |
|
SPACE |
generates a string consisting of a specified number of blank spaces. |
|
SQUOTE |
encloses an expression in single quotation marks. |
|
STR |
generates a particular character a the number of times specified. |
|
TRIM |
deletes the spaces and tabs before the first non-blank character in a string and after the last non-blank character, then returns the new string. |
|
BTRIM |
deletes all the spaces and tabs after the last non-blank character in a string and returns the new string. |
|
FTRIM |
deletes all the spaces and tabs preceding the first non-blank character in a string. |
|