MiddleValues function

Contents > Functions reference (alphabetical list) > Text functions > MiddleValues function

MiddleValues function

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

Description

Returns a text result containing the specified numberOfValues in text, starting with startingValue.

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

Contents > Functions reference (alphabetical list) > Text functions > MiddleValues function