Reference > Functions reference > Text functions > GetValue
 

GetValue

Returns the requested value given by valueNumber from listOfValues.

Format 

GetValue ( listOfValues ; valueNumber )

Parameters 

listOfValues - a list of carriage return-delimited values

valueNumber - the value to return from the list

Data type returned 

text

Originated in version 

8.0

Description 

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

GetValue returns the specified value without a trailing carriage return.

Example 1 

GetValue ( "LondonĀ¶ParisĀ¶Hong Kong" ; 2 ) returns Paris.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas