Regex Replace
Overview
This article will cover how to use regular expressions (RegEx) to match and replace data.
1. Add RegEx Replace in Your Dataflow
2. RegEx Replace Options
1. Add RegEx Replace in Your Dataflow
Add RegEx Replace to any node in your Dataflow. Select any node and use the Transform (+) button to open the list of options to select RegEx Replace. You could work with the node in the Dataflow tab or use the Properties panel.
2. RegEx Replace Options
RegEx Replace node has four fields to help replace values in structured data. Read along to see how we remove the gender suffix from sample data.
2.1 Select Column
The first dropdown lets you choose which data field you want to change.
2.2 Match Expression
The Match field is a textbox used to type a regular expression to find data with specific criteria.
Note: A column can only be used once (in a single operation row). Click on the Replace Another button to add a new RegEx condition.
2.3 Flags
The third field lets you choose from two RegEx flags.
Note: You may select either Global, Case Insensitive, or both.
2.4 Replace
The third option lets you determine which value to replace.
Here's what the sample data looks like after our regular expression.
Related articles
Next steps
Other Topics
