PICKZEN
Search
K

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

mytable
  • EXTRACT(mytable, '1:2') returns:
  • EXTRACT(mytable, '2:3', 'B:C') returns:
  • EXTRACT(mytable, '2:', ':C') returns:
Last modified 3yr ago