String Functions¶
The following functions are available to perform string manipulations:
| Function | Description |
|---|---|
| Asc | Returns the ANSI character code of the first character in a string. |
| Chr | Returns the character associated with the specified ANSI character code. |
| Instr | Returns the starting position of the first occurrence of one string within another. |
| InstrRev | Returns the starting position of the last occurrence of one string within another. |
| LCase | Returns a string with all characters converted to lowercase. |
| Left | Returns the leftmost characters of a string up to a specified length. |
| Len | Returns the number of characters in a string. |
| LTrim | Returns a string with leading spaces removed. |
| Mid | Returns a substring of specified length and position from the value of the input string. |
| NumberToRoman | Returns a Roman presentation of an integer. |
| ProperCase | Formats a string by upper- and lowercasing the input value using optional rules. |
| Replace | Returns a string with all occurrences of a specified substring in a host string replaced with a new substring. |
| Right | Returns the rightmost characters of a string up to a specified length. |
| RTrim | Returns a string with trailing spaces removed. |
| Space | Returns a string consisting of the specified number of spaces. |
| StrComp | Compares two strings and returns an integer indicating the result of the comparison. |
| String | Returns a string that contains a repeating character of a specified length. |
| StrReverse | Returns a string with the order of the characters reversed. |
| Trim | Returns a string with leading and trailing spaces removed. |
| UCase | Returns a string with all characters converted to uppercase. |