User Tools

Site Tools


Right(text, no_of_chars)

Category: Text function


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


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


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.


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

syntax/functions/right.txt · Last modified: 2021/08/14 22:30 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki