String-Handling Functions
 
 
 

The expression evaluator supports the following string-handling functions. The words in italics can be replaced by an actual value or a variable.

Expression Description
(strcase string [which] ) Returns a string where all alphabetic characters have been converted to uppercase or lowercase.
(strcat string1 [string2] ...) Returns a string that is the concatenation of multiple strings.
(strlen [string] ...) Returns an integer that is the number of characters in a string.
(substr stringstart [length] ) Returns a substring of a string.
(chr integer) Returns the conversion of an integer representing an ASCII character code into a single-character string.
(LPAD stringlength) ads the beginning of a string with spaces until the string reaches the length specified.
(RPAD stringlength) ads the end of a string with spaces until the string reaches the length specified.
(trim string [mode] ) Trims strings from the beginning, middle, or end of a string based on the mode. Mode can be B (beginning), M (middle), or E (end), or any combination. If no mode is specified, BE is used.