csl_pick(X;Y)

Returns a particular element in a given comma-separated list.

Syntax

csl_pick(X;Y)

Input

Argument Type Description
X text A comma-separated list or the name of a column containing a comma-separated list
Y integer The index of an element within the comma-separated list

Return Value

Returns the element in the comma-separated list X corresponding to the index Y. The index is 1-based (e.g., the first element in the list is returned when Y=1).
Note: A negative index counts back from the end of the list (e.g., Y=-1 references the last element in the list).

If X is N/A, the result is N/A.

If |Y| is greater than the number of elements in the list, the result is N/A.

Sample Usage

csl_list index csl_pick(csl_list;index)
'dog,cat,bird,horse,hippo,duck' 2 'cat'
'dog,cat,bird,horse,hippo,duck' -2 'hippo'
'dog,cat,bird,horse,hippo,duck' 15
'dog,cat,bird,horse,hippo,duck' -15
'' 2