MiddleValues
Purpose 
Returns a text result containing the specified numberOfValues in text, starting with 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
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. 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 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.