## Examples

`LEFT("123 Maple Dr", 5)` : 123 M

`LEFT("123 Maple Dr", 0)` returns blank.

#### First & Last Initials

Initials from a first and last name:

``LEFT([First Name], 1) & LEFT([Last Name], 1)``
• `LEFT(..., 1)` gets the first character of the specified column value.
• `LEFT(...) & LEFT(...)` concatenates the two initials into a single text value.

Equivalent to `INITIALS(CONCATENATE([First Name], " ", [Last Name]))`.

#### Integer Component of Decimal Value

The integer component of a Decimal value in the Result column:

``NUMBER(  LEFT(    TEXT([Result]),    (FIND(".", TEXT([Result])) - 1)  ))``
• `TEXT([Result])` converts the Decimal value to a Text value. The textual functions used in this example interpret non-textual values differently. Using TEXT() ensures the Result column value is interpreted the same by each function.
• `(FIND(".", ...) - 1)` locates the character immediately preceding the decimal point.
• `LEFT(..., ...)` extracts the integer part.
• `NUMBER(...)` converts the extracted text to a Number.

Equivalent to `FLOOR([Result])`.

#### Street Number from Street Address

The first word of an address, which is typically the street number:

``LEFT([Address], (FIND(" ", [Address]) - 1))``
• `FIND(" ", [Address])` locates the first/leftmost space in the Address column value.
• `FIND(...) - 1` locates the character immediately preceding the first space.
• `LEFT([Address], ...)` returns the leftmost text preceding the first space.

Equivalent to `INDEX(SPLIT([Address], " "), 1)`.

## Syntax

LEFT( some-text , how-many )

## Arguments

• some-text (any textual type)
• how-many (Number) : The number of characters from some-text to return. Non-Number values may be accepted but may produce unexpected results.

## Return Value

Text: The first how-many characters from some-text. If how-many is greater than the length of some-text or less than 0, some-text is returned in its entirety.