Parse Text with Regular Expression

Extracts text from a column to new columns using regular expression capturing groups.

Example

Configuration

The following options are available when configuring this transform.

Parse Type

Reg ex should be selected for this transform.

Column

Select a column that you want to extract text with capturing groups from.

Regex

Enter your own Regular Expression capturing groups to extract from the column or choose from a number of predefined options

Where

Add a condition defining when to apply this transform.

Adding the Transform

1. Click + Add Script Step on the right of the wrangler.
2. Find Parse text transform under Column Manipulation group.

Key Considerations

• Applying this transform removes the original column.
• Compares to Extract Text, Parse Text using Regular Expression provides more flexibility by not having a Max limit on the number of match instances.
• The default names for the new columns are parse, parse1 etc. To rename them, you can use the Rename transform.

Related Transforms

• Cut Text
• Edit Text
• Extract Text
• Change Case
• Replace Substring