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
Right
right returns the rightmost characters from a string, including spaces.
You specify the number of characters to be returned.
Syntax
right(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 last character in the string.
Return type
String
Example
The following example returns the last five characters from a string.
right('Seattle Store#14', 12)
The following value is returned.
tle Store#14
