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

1. Click Add rule.
2. 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.
3. Click Add column.
4. From the dropdown list, select the columns whose values you want to transform.
5. In the Regular expression field, enter the regular expression formula.
6. 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.
7. In the Value field, enter the expression you want to replace the original value with.
8. 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.
9. 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.

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

      

6. Click Apply.
7. Add the Data Output node.
8. Join the node with the Regex Replace node.