EXTRACT
The EXTRACT function returns a sub-table from a table.
Last updated
The EXTRACT function returns a sub-table from a table.
Last updated
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.
EXTRACT(mytable, '1:2') returns:
EXTRACT(mytable, '2:3', 'B:C') returns:
EXTRACT(mytable, '2:', ':C') returns: