MiddleValues

Returns text containing the specified numberOfValues in text, starting at startingValue.

Format 

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 

For a description of a list of values, see ValueCount function.

Each returned value ends with a carriage return, allowing lists to be easily concatenated.

If startingValue ≤ 1, then this function is evaluated as if startingValue = 1. If startingValue is greater than the number of values in text, this function returns nothing.

Example 1 

MiddleValues ( "Plaid¶Canvas¶Suitcase" ; 2 ; 1 ) returns Canvas¶.

Example 2 

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