Text functions

Concatenate

Concatenates the supplied set of strings into one string.
Example: CONCATENATE('One', 'Two', 'Three')

Returns a specified number of characters from the start of the supplied string
Example: LEFT('abacd', 2)

Returns the length of the supplied string
Example: LEN('abc')

Returns the supplied string in lower case
Example: LOWER('ABC')

Example: MID('abacd', 2, 2)

Replaces a part of a text string with another string from the supplied position.
Example: REPLACE('testar', 3, 3, 'hej')

Returns a specified number of characters from the end of the supplied string
Example: RIGHT('abacd', 2)

Example: SUBSTITUTE('testing testing', 'es', 'xx')

Example: TEXT(2)

Returns the supplied string in upper case
Example: UPPER('abc')