Filemaker Pro 8.5 Educational Maintenance T0 TJ087LL/A User Manual
Product codes
TJ087LL/A
Chapter 12
|
Text functions 177
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 with
startingValue.
Values are text items separated by carriage returns. 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.
Each value that is returned ends with a carriage return, allowing lists to be easily
concatenated.
startingValue.
Values are text items separated by carriage returns. 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.
Each value that is returned ends with a carriage return, allowing lists to be easily
concatenated.
Examples
MiddleValues(“Plaid¶Canvas¶Suitcase”;2;1) returns
Canvas
MiddleValues(list;2;2) returns
Bill
John
John
when the list field contains
Sophie
Bill
John
Sophie
Bill
John
MiddleWords
Format
MiddleWords(text;startingWord;numberOfWords)
Parameters
text - any
startingWord - any numeric expression or field containing a number
numberOfWords - any numeric expression or field containing a number
numberOfWords - any numeric expression or field containing a number
Data type returned
text