# Extract Text ## Overview The Extract Node allows you to extract specific text from one or multiple columns in your dataset and place the extracted text into separate columns or arrays.
## **Settings** #### **Extract From** In the "Extract From" property, select one or multiple columns that you want to extract text. The selected columns should contain text data that can be processed using the specified text or pattern. #### **Find** Specify the text or pattern to find and extract using the "Find" property. You can choose between a text string or a regular expression (regex) pattern: 1. Text string: Enter a simple text string that will be used to find and extract the text from the column values.
2. Regex pattern: Enter a regular expression pattern that will be used to find and extract the text from the column values. Find out how to use Regex [Using Regex](/tutorials/using-regex.md) and the list of supported tokens [Regex: List of Tokes](/data-transformation/formulas/regex-list-of-tokes.md)
#### **Set into** In the "Set Into" property, choose one of the following options for the output format: #### **Array** If you select "Array," the Extract Node will create a new column containing arrays with the extracted text parts. #### **Columns** If you select "Columns," the Extract Node will create separate columns for each extracted text part. You need to specify the number of columns to be created. By default, two columns will be created. A maximum of 50 columns can be created. #### **Ignore case** Enable the "Ignore Case" toggle if you want the extraction process to be case-insensitive. When this option is enabled, the Extract Node will not differentiate between uppercase and lowercase characters when finding and extracting the text. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.tabula.io/data-flows/tools-nodes/columns-operations/extract-text.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.