Returns a substring that begins at the start of a given string column values.
Category: text
Syntax:
Left([string_column], number)
StringColumn
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
string_column | column | ✓ Yes | The string column from which a left substring will be returned. |
number | number | ✓ Yes | The desired length of the returned substring. A negative number removes characters from the end. |
Validation
- Minimum parameters: 2
- Maximum parameters: 2
Examples
Returns first 5 characters of each address.
- Right - Extract from end of string
- Upper - Convert extracted text to uppercase
Last modified on March 13, 2026
