Using start, stop and step to define a range of indices, the corresponding range of elements is extracted from each text or list in the input column.

Note: indices start at 0, and a stop of 3 means elements up to but not including the element at index 3 will be extracted. In particular this means simply specifying "stop": 3 (setting or leaving start at its default of 0), will extract 3 elements in total.

start
[integer, null]

Index of the first element to be extracted from each string or list in the input column.

stop
[integer, null]

Index at which to stop including elements from the list. The element at the stop index will not be included. As an example, "start": 0, "stop": 3 will include all elements up to but not including the element at index 3, thus extracting a total of 3 elements.

step
[integer, null]
default: "1"

Step size used to move from start to stop index. E.g., if "step": 2, only every second element from the range [start, stop] is returned.

out_type
string

Select types using their name.

Values must be one of the following:

category date number boolean url sex text list[number] list[category] list[url] list[boolean] list[date]

Was this page helpful?