| Syntax | Description | Example |
|---|---|---|
| ARGB(nA, nR, nG, nB) | Returns a valid color string in ARGB format. All color components are automatically clamped to the [0:255] range. | ARGB(128, 255, 0, 0) Returns: "(128,255,0,0)" |
| CHAR(nNumber) | Returns the character for a number. The resulting string is one character in length. | CHAR(9) Returns: tab character |
| FORMAT(var[,sFormat][,sCulture]) |
Returns a formatted string representing a variant value. If format is not specified the default system format is used. If format is specified you can also specify a culture. If culture is not specified the default current culture is used. For number variants the format string should be a number format string. See Numeric Format Strings. For date time variants the format string should be a date time format string. See: Date Time Format Strings. |
(assuming current culture is en-US") FORMAT(10) Returns: "10" FORMAT(0.255555, "p") Returns: 25.56 % FORMAT(1000, "c") Returns: $1,000.00 FORMAT(1000,"c","en-GB") Returns: £1,000.00 FORMAT(DATETIME("2008-09-15T09:30:41.77"),"d") Returns: 9/15/2008 FORMAT(DATETIME("2008-09-15T09:30:41.77"),"d","en-GB") Returns: 15/9/2008 |
| LEN(sString) | Returns the number of characters in a text string. | LEN("Hello World") Returns: 11 |
| JOIN(arr, sDelimiter) | Returns a string variant, which represents the concatenation of the string representations of the variants contained in the array, delimited with delimiter. | JOIN(ARRAY("Hello","World"), ";") Returns: Hello;World |
| LIKE(sString, sPattern) |
Returns true if the pattern was found at least once in the string. The pattern is a regular expression. See: |
LIKE("Hello World", "ello") Returns: true LIKE("Hello World", "elllo") Returns: false |
| LOWER(sString) | Returns a string converted to lowercase. | LOWER("Hello World") Returns: "hello world" |
| REPLACE(sString, sOldText, sNewText) | Replaces all occurrences of old text in a string with the specified new text. | REPLACE("Hello World", "Hello", "Beautiful") Returns: "Beautiful World" |
| RGB(nR, nG, nB) | Returns a valid color string in RGB format. All color components are automatically clamped to the [0:255] range. | RGB(255, 0, 0) Returns: "(255,0,0)" |
| SPLIT(sString, sSeparator[, bRemoveEmpty]) |
Splits the string, by the specified separator. Optionally you can specify whether empty strings are to be removed - by default they are not removed. Returns an array of strings. |
SPLIT("Hello World", " ") Returns: an array containing "Hello", "World", "Hello", "World" |
| STRSAME(sString1, sString2[, ignoreCase]) | Returns true if the string are the same. Otherwise returns false. The optional ignoreCase argument indicates whether to perform case-insensitive comparison (by default it is false). |
STRSAME("Hello", "hello") STRSAME("Hello", "hello", true) |
| TRIM(sString) | Removes all space from string except for single spaces between words. | TRIM(" Hello World ") Returns: "Hello World" |
| UPPER(sString) | Returns a string converted to uppercase. | UPPER("Hello World") Returns: "HELLO WORLD" |