| Text Functions |
| Name |
Description |
| char |
Unicode character for a numerical code |
| clean |
Remove non-printable characters from text |
| code |
Unicode value for a character |
| currency |
Displays a value in the system currency format |
| concatenate |
Concatenate text: concatenate( text1, text2 ... ) |
| find |
Returns the position of the given string in the second string:
- find("e", "Hello World") -> 2
- find("o", "Hello World", 6) -> 8
|
| join |
Join text using separator: join( separator, text1, text2 ... ) |
| left |
Substring starting from the left: left("Hello World", 5) -> "Hello" |
| len |
Length of string, in characters: len("ABC") -> 3 |
| lower |
Lower case string: lower("I am FINE") -> "i am fine" |
| mid |
Substring starting from the middle: mid("Hello World", 2, 4) -> "ello" |
| percent |
Displays a value in the system percent format |
| proper |
Proper (mixed-case) string: lower("i am FINE") -> "I Am Fine" |
| replace |
replace(text, start index, number of characters, replacement) |
| rept |
Repeat a string a number of times: rept("ABC", 3) -> "ABCABCABC" |
| right |
Substring starting from the right: right("Hello World", 5) -> "World" |
| search |
Returns the position of the given string in the second string, using case-insensitive wildcards:
- search("e", "Hello World") -> 2
- search("o", "Hello World", 6) -> 8
- search("or*", "Hello World") -> 8
|
| split |
Splits a string into tokens: split("A,B,C", ",") results in the list ["A","B","C"] |
| substitute |
Replace text:
- substitute(text, old text, new text)
- substitute(text, old text, new text, instance number)
|
| trim |
Remove whitespace from start and end of text: trim(" ABC ") -> "ABC" |
| upper |
Upper case string: upper("i am fine") -> "I AM FINE" |
| value |
Numeric value : value("13") -> 13.0 |
