MiddleValues
Purpose
Returns text containing the specified numberOfValues in text, starting at startingValue.
Format
MiddleValues(text;startingValue;numberOfValues)
Parameters
text - any
text expression or text
field startingValue - any numeric expression or field containing a number
numberOfValues - any numeric expression or field containing a number
Data type returned
text
Originated in
FileMaker Pro 7.0
Description
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
when the list field contains
Sophie
Bill
John
Related topics