ExtractArray()

Returns the specified sub-array, which must itself be an array.

subarr = ExtractArray(array arr, int idx)

Argument	Contents
arr	An array with sub-arrays
idx	The index of an element that is a sub-array

The specified sub-array, or null if the element is not a sub-array.

ExtractArray() can be used in situations such as formula fields where you cannot use the format arr[idx] to indicate an array element.

arr = {{"a","b"}, {"c","d"}, {1, 2, 3}}

subarr = ExtractArray(arr, 2) // subarr = {"c","d"}

int = A2I(ExtractArray(arr, 3), 1) // int = 1

Function	Summary
ArrayElementToInteger()	Converts an array element to an integer
ArrayElementToReal()	Converts an array element to a real number
ArrayElementToString()	Converts an array element to a string