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.