Reference > Functions reference > Text functions > MiddleValues

MiddleValues

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.

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