EXTRACT
The EXTRACT function returns a sub-table from a table.
Syntax
EXTRACT(table, [rowSelector, colSelector, includeHeader])
Argument name | Description |
table Required | Origin table. |
rowSelector Optional | Selector of rows. All rows by default. |
colSelector Optional | Selector of columns. All columns by default. |
includeHeader Optional | Determines whether including the header in the resulting table. True by default. |
Examples
EXTRACT(mytable, '1:2') returns:
EXTRACT(mytable, '2:3', 'B:C') returns:
EXTRACT(mytable, '2:', ':C') returns:
Last updated
