pick(X;L)

Returns the item in a specified list at the position denoted by the given value.

Syntax

pick(X;L)

Input

Argument Type Description
X integer The position within the list L

A scalar value or the name of a column

L any A space or comma-separated list of values

All of the values in L must be the same type (integer, decimal, or text).

Return Value

Returns the Xth item in the list L.

If X is greater than the number of items in L, the result is N/A.

Sample Usage

X L pick(X;L)
2 10 20 30 20
2 'a' 'bb' 'ccc' 'bb'
4 1.1 1.2 1.3 NA
2 'a' '' 'ccc' ''