Overview

Extracts characters, digits or complete strings of a selected column to a new column using a regular expression (Regex). 

Input

The Processor is able to operate on any dataset. Nevertheless, it makes sense for the target column to contain string values.

Configuration

Output

The output of the Extract Regex Processor is the original dataset with an additional column that contains the extracted pattern.

Example 

Example Input

Workflow

Example Configuration

The used regular expression selects the words that start with a capital letter in a given input text (more precisely, select the substring that starts with a capital letter).

Consult the following link for more about Regex syntax.

Result

Related Articles

Search And Replace Processor