Extract Text

Extracts the specified part of text into a new column(s)

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 and the list of supported tokens Regex: List of Tokes

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.