LEFT function

LEFT(text, length?) LEFT(text; length?)

text — Text or { Text }

The string from which to extract a part.

length — Number or { Number } (optional)

The number of characters to include. If omitted, 1 is assumed, meaning that only the first character of the text string is returned.

Returns — Text or { Text }

Text from the left side of the given text string.

Returns text from the left side of a text string.

Examples

LEFT("abcd")LEFT("abcd")

Returns "a", the first character of "abcd".

LEFT("abcd", 2)LEFT("abcd"; 2)

Returns "ab", the first two characters of "abcd".

LEFT(TextField1, LEN(TextField1) / 2)LEFT(TextField1; LEN(TextField1) / 2)

Returns the first half of the value of TextField1. LEN returns the length of a text string.