Extract Text
Extracts the specified part of text into a new column(s)
Last updated
Extracts the specified part of text into a new column(s)
Last updated
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.
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.
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:
Text string: Enter a simple text string that will be used to find and extract the text from the column values.
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 and the list of supported tokens Regex: List of Tokes
In the "Set Into" property, choose one of the following options for the output format:
If you select "Array," the Extract Node will create a new column containing arrays with the extracted text parts.
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.
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.
