Menu
Amazon QuickSight
User Guide

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