LEFT function

LEFT(Text, Length?) LEFT(Text; Length?)


Text or { Text }

The string from which to extract a part.


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.


Text or { Text }

Text from the left side of the given text string.

Returns text from the left side of a text string.



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.