Filemaker Pro 8.5 Educational Maintenance T1 TJ086LL/A User Manual
Product codes
TJ086LL/A
Chapter 12
|
Text functions 183
Parameters
text - any
numberOfValues - any numeric expression or field containing a number
Important
See chapter 4, “Design functions” for information about literal text parameters.
Data type returned
text
Description
Returns a text result containing the specified numberOfValues in text starting from the
right.
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
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.
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
Suitcase
RightValues(names;1) returns
John
when the names field contains
Sophie
Bill
John
Sophie
Bill
John
RightWords
Format
RightWords(text;numberOfWords)
Parameters
text - any