Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.
To find a feature or item, use the Quick search bar.
For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight
Left
left
returns the leftmost characters from a string, including spaces.
You specify the number of characters to be returned.
Syntax
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 3 characters from a string.
left('Seattle Store #14', 3)
The following value is returned.
Sea