Replace strings via a transformation list

This format replaces the given value or parts of it via transformation lists. The transformation lists define how they are replaced. The following replacement methods are supported:

• Exact source value check: The whole incoming value is compared. If it matches with one of the source values, the corresponding target value will be returned.
• Replace all occurrences: The incoming value is searched for all occurrences of the given source values. These are then replaced by their target values.
• Replace all regular expression occurrences: The incoming value is scanned using the given regular expressions (regex). All matches are then replaced by their target values.

How to use

In this example, I want to replace the HTML breaks <br> with the newline control character \n.

Select the format in the datamap row.

Select the transformation list, you want to use. Use the button next to the selection to open the overview and be able to create a new transformation list.

In the transformation list creation, select the replacement mode and add the replacements. The replacement table will be visible available after saving the base list. If you are replacing via regex, do not forget to add the delimiters like /search/ or !search!.

In my case, the HTML breaks are replaced with a newline.

The transformation lists are so incredibly useful because they can be re-used across all connector configurations and even between connectors. You can access the overview of all transformation lists at any time in the connector suite here. Note: Changes to an existing transformation list will affect all existing formats that use it.