Functions Reference

FILEMAKER FUNCTIONS REFERENCE 237
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
Related topics
Contents
Functions reference (alphabetical list)
RightWords
Purpose
Returns a text result containing the numberOfWords in text, counting from the right.
Format
RightWords(text;numberOfWords)
Parameters
text - any text expression or text field
numberOfWords - any numeric expression or field containing a number
Data type returned
text