Extract from array

Extract an element or a sub-array from an array written in JSON.

Options

Input column

Column to extract element or array.

Mode

Choose from:

  • Extract an element: Provide the element’s index number. Use negative index to count from the end of the array: (-1 is the last value, -2 is second to last, etc).

  • Extract a sub-array: Provide the starting and ending index numbers.

Output column

Create a separate output column or leave blank to perform extraction in-column.