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 version 

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