Table of Contents

Right(text, no_of_chars)

Category: Text function


Description

This function returns the specified number of symbols from the right of text as a text value.


Arguments

ArgumentTypeDescription
textTextThe text value to extract the symbols from.
no_of_charsInteger, minimum of 0The number of symbols returned from the right side of the text argument.

Return value type: Text


Remarks

Regardless of the type of value passed in for text, the result of this function is always a text value.

Entering a no_of_chars of 0 will return an empty value. Entering a no_of_chars greater than the length of text will result in the full text value being returned.

Numbers and equations can be used as the text argument and are implicitly converted to their text-equivalent. When passing in an equation for text, no_of_chars number of symbols from the equation's result will be returned.

Passing in a date value (#yyyy-MM-dd) will return no_of_chars number of symbols from the converted date serial value. See the examples below.


Examples

right('Los Angeles', 3) //Returns 'les'
right('IT services', 8) //Returns 'services'
right('Canada',10) //Returns 'Canada'
right('EasyMorph',0) //Returns ''  (Empty value)
right(12345, 3) //Returns '345'  (Note, the numeric value of 12345 was passed in.  The result is a text value.)
right(#2021-10-21, 3) //Returns '490'  (2021-10-21 is 44490 as a date serial value, so '490' is returned.)
right(100*3, 1) //Returns '0'  (The result of 100 * 3 = 300, so '0' is returned as the rightmost character.)


See also