RightValues
Returns values contained in text, according to the specified numberOfValues, counting from the right.
Format
RightValues ( text ; numberOfValues )
Parameters
text - any text expression or text field
numberOfValues - any numeric expression or field containing a number
Data type returned
text
Originated in version
7.0
Description
For a description of a list of values, see ValueCount function.
Each returned value ends with a carriage return, allowing lists to be easily concatenated.
Example 1
RightValues ( "Plaid¶Canvas¶Suitcase" ; 2 ) returns Canvas¶Suitcase¶.
Example 2
RightValues ( names ; 1 ) returns John¶ when the names field contains
Sophie
Bill
John