RIGHT

Description

The RIGHT function extracts a specified number of characters from the end of a text value.

Usage

RIGHT(text, number_characters)
Argument Type Required Description
text Text Yes The input text
number_of_characters Numeric Yes The number of characters to include

Remarks

If the text argument is blank, or number_of_characters is zero, then the result is will be a blank text value.

Right-to-left languages

Note that while the name of the function, "RIGHT", is inherited from Excel, it always refers to the end of the text, regardless of the writing direction. For Right-to-left languages, the RIGHT function extracts the given number of characters from the end of the string, which would actually be the left-most characters visually speaking.

For example, the formula RIGHT("سلام الکس", 4) is equal to "الکس".

Example

Sometimes registration or national ID numbers encode information about their holders. For example, in Switzerland residents used to be issued an eleven-digit format in the form AAA.BB.CCC.DDD where the "DDD" digits are an origin code

You could extract these last four digits using the formula:

RIGHT(NATIONAL_ID, 4)
Next item
COUNTDISTINCTX