csl_drop(X;Y)
Returns all but the first number of elements in a given comma-separated list.
Syntax
csl_drop(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 a comma-separated list consisting of all but the first
Y
elements
in the comma-separated list X
. The index is 1-based (e.g., the first two
elements in the list are dropped when Y
=2).Note: A
negative index counts back from the end of the list (e.g.,
Y
=-2 drops the last two 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_drop(csl_list;index) |
---|---|---|
'dog,cat,bird,horse,hippo,duck' | 2 | 'bird,horse,hippo,duck' |
'dog,cat,bird,horse,hippo,duck' | -2 | 'dog,cat,bird,horse' |
'dog,cat,bird,horse,hippo,duck' | 15 | |
'dog,cat,bird,horse,hippo,duck' | -15 | |
'' | 2 |