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 returns the rightmost characters from a string, including spaces. You specify the number of characters to be returned.


right(expression, limit)



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.


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

Return Type



The following example returns the last five characters from a string.

right('Seattle Store#14', 12)

The following value is returned.

tle Store#14