Text functions

Jump to bottom Edit New page

swmal edited this page Mar 31, 2012 · 15 revisions

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

Example: REPLACE('testar', 3, 3, 'hej')

Right

Example: RIGHT('abacd', 2)

Substitute

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