Menu
Amazon QuickSight
User Guide

left Function

left returns the leftmost characters from a string. You specify the number of characters to be returned.

Syntax

Copy
left(expression, limit)

Arguments

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

limit

The number of characters to be returned from expression, starting from the first character in the string.

Return Type

String

Example

The following example returns the first 5 characters from a string.

Copy
left('Seattle Store#14', 5)

The following value is returned:

Copy
Seatt