Menu
Amazon QuickSight
User Guide

right Function

right returns the rightmost characters from a string, including spaces. You specify the number of characters to be returned.

Syntax

Copy
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 5 characters from a string.

Copy
right('Seattle Store#14', 12)

The following value is returned:

Copy
tle Store#14