# EXTRACT

### Syntax

**EXTRACT(table, \[rowSelector, colSelector, includeHeader])**

| Argument name                                        | Description                                                                      |
| ---------------------------------------------------- | -------------------------------------------------------------------------------- |
| <p><strong>table</strong></p><p>Required</p>         | Origin table.                                                                    |
| <p><strong>rowSelector</strong></p><p>Optional</p>   | Selector of rows. All rows by default.                                           |
| <p><strong>colSelector</strong></p><p>Optional</p>   | Selector of columns. All columns by default.                                     |
| <p><strong>includeHeader</strong></p><p>Optional</p> | Determines whether including the header in the resulting table. True by default. |

### Examples

![mytable](https://1947171238-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LrTaL6FQB3RzlkCwQfN%2F-MA5cSo6gqMZaIBE9Mo_%2F-MA5dmJVq-tZGP6DMl08%2Fimage.png?alt=media\&token=022d666a-08b4-4c40-aade-96cd26597332)

* EXTRACT(mytable, '1:2') returns:

![](https://1947171238-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LrTaL6FQB3RzlkCwQfN%2F-MA5cSo6gqMZaIBE9Mo_%2F-MA5dxBDZi58Y7cAo0L_%2Fimage.png?alt=media\&token=21f330af-2a73-42ed-8bf4-144bc97675aa)

* EXTRACT(mytable, '2:3', 'B:C') returns:

![](https://1947171238-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LrTaL6FQB3RzlkCwQfN%2F-MA5cSo6gqMZaIBE9Mo_%2F-MA5e_dkVjbXz4rJEMZo%2Fimage.png?alt=media\&token=f7e5b2e2-f802-4386-8c50-f27a51fc1d10)

* EXTRACT(mytable, '2:', ':C') returns:

![](https://1947171238-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LrTaL6FQB3RzlkCwQfN%2F-MA5cSo6gqMZaIBE9Mo_%2F-MA5ep2a_ehSfosnBCAl%2Fimage.png?alt=media\&token=65b78422-8344-47ee-8f59-94673ee6deba)