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: