Functions Reference

Text functions
F
ILEMAKER FUNCTIONS REFERENCE 324
RightValues
Purpose
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
Important See Design functions for information about literal text parameters.
Data type returned
text
Originated in
FileMaker Pro 7.0
Description
Values are text items separated by carriage returns. You can place several items together to create
a carriage return-delimited list of values. A value can be empty, a single character, a word, a
sentence, or a paragraph. When you press Return you start creating a new value. The last value will
be recognized with or without a carriage return.
When the text parameter is a literal string as in the example below, you must insert a literal
carriage return character between each item in the list. In the Specify Calculation dialog box, click
the ¶ button to insert a literal carriage return character.
Each value that is returned ends with a carriage return, allowing lists to be easily concatenated.
Examples
RightValues(“Plaid¶Canvas¶Suitcase”;2) returns
Canvas
Suitcase
RightValues(names;1) returns
John
when the names field contains
• Sophie
• Bill
• John