Logo Docs
Logo Docs

LEFT

Returns a specified number of characters from the beginning (left) of a text

Usage

LEFT(text, num_chars)

Parameters

text

(Required) The text from which to extract characters.
num_chars

(Required) The number of characters to extract from the left of the text.

Examples

Example With these variables Result

LEFT(“Anna Logwatch”, 4)

 (None)

“Anna”

LEFT(name, 2)
name is "Anna Logwatch"

“An”

LEFT(name, 50)
name is "Anna Logwatch"

“Anna Logwatch”

More information

The LEFT function extracts characters from the beginning (left) of the text up to the num_chars limit.

If num_chars is greater than the length of the text, the entire text is returned.

See also