Extract from array¶
Extract an element or a sub-array from an array written in JSON.
Column to extract element or array.
- 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.
Create a separate output column or leave blank to perform extraction in-column.