Amazon QuickSight
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

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