Regex Replace
If you need to collectively edit values in the columns, you can use Regex Replace node. It allows you to replace a group of values that share the same pattern with a new value or just a part of the value.
Node configuration
- Click Add rule.
- Select one of the two available options:
- Include these - the default; it allows you to select the columns that will be considered.
- Include all except these - this option excludes values that match the regular expression in a selected column.
- Click Add column.
- From the dropdown list, select the columns whose values you want to transform.
- In the Regular expression field, enter the regular expression formula.
- From the Replace dropdown list, select one of the options:
- Matching pattern - only the part of the value which matches the regular expression is replaced.
- Entire value in the cell - a whole value is replaced.
- In the Value field, enter the expression you want to replace the original value with.
- To add more rules, click Add rule and repeat steps from 2 to 7.
Tip: You can preview the results in the Output data tab. - Click Apply.
Example of use
You can replace the part of the domain in the email addresses of your customers - from .com
to .co.uk
. You can use this transformation in the further processes, for example, in importing customers to Synerise.

- Start the transformation with the Data Input node.
- Click the node.
- Upload a file on which you want to perform data transformation.
- Add the Regex Replace node and join it with the Data Output node.
- In the configuration of the Regex Replace node:
- Click Add rule.
- Select Include these
- Select the column with email addresses.
- In the Expression field, enter
\.com$
- From the Replace dropdown list, select Matching pattern.
- In the Value field, enter
.co.uk
Changes applied
- Click Apply.
- Add the Data Output node.
- Join the node with the Regex Replace node.