lst_drop(L;N)

Returns a list-value of all elements after a given element.

Syntax

lst_drop(L;N)

Input

Argument Type Description
L list-value The name of the list-value whose indexed values will be returned

If L is omitted, an error is returned.

If L is N/A, an error is returned.

A list-value

N integer The number of indexed elements to drop, starting at 1 and dropping every element up to and including element N

If N is negative, the index counting begins at the end of the list-value drops the through the N'th to last element.

If N is omitted, an error is returned.

If N is N/A, an error is returned.

A scalar value

Return Value

Returns every indexed value after the N'th element of list-value L as a comma-separated list.

Sample Usage

The following example demonstrates how the lst_drop(L;N) function returns a comma-separated list of only the indexed values in list after element 2.

<let list="{lst(1 'a' 'A' 3.14159)}">
  <willbe name="element_values" value="'{lst_drop(@list;2)}'"/>
</let>

The code above creates a computed column with the value: A,3.14159.

Example: Get the values after the first N elements of list-value L

Once a list-value is created, values after any index position can be retrieved using the lst_drop(L;N) function.

<let list="{lst('De La Soul' 'A Tribe Called Quest' 'Pharcyde')}" whosingsdrop="2">
  <willbe name="artist" value="'{lst_drop(@list;@whosingsdrop)}'"/>
</let>

The code above creates a computed column with the value: Pharcyde.