RightValues

Returns values contained in text, according to the specified numberOfValues, counting from the right.

Format 

Parameters 

text - any text expression or text field

numberOfValues - any numeric expression or field containing a number

Data type returned 

text

Originated in 

FileMaker Pro 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

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas