GetValue function

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

GetValue function

Format


GetValue(listOfValues;valueNumber)

Parameter

listOfValues - a list of carriage return-delimited values

valueNumber - the value to return from the list

Data type returned

text

Description

Returns the requested value given by valueNumber from listOfValues. Useful in looping scripts or recursive custom calculations.

Values are text items separated by carriage returns. You can place several values together to create a carriage return-delimited list of values. A value can be empty, a single character, a word, a sentence, or a paragraph. When you press Enter or Return, you start creating a new value. The last value will be recognized with or without a carriage return.

When the listOfValues parameter is a literal string, you must insert a literal carriage return character (¶) between each item in the string. To insert a literal carriage return character, click the ¶ button in the Specify Calculation dialog box.

Example

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

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