Text functions

Concatenate

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

Left

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

Len

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

Lower

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

Mid

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

Replace

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

Right

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

Substitute

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

Text

Example: TEXT(2)

Upper

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

---

Home