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. |