Page Comparison

Overview

This article contains Tips & Tricks on the use of transformations in DataBridge.
It is an article in progress and we would love your input also. So if you have a use case or have an idea about a new transformation please send us an email at support@infobridge.comMore info on import transformations
More info on export transformations

Use cases

Clean field

Cleans a text field using a specific cleaning option. All cleaning options include white space, commas and periods. 
Clean number removes all non-digit characters.
Clean text removes all special characters like dashes and dots.

In this example we want to clean VAT numbers.

In the transformation Clean field we choose the correct column and the clean option clean number

Image Modified

Below you can see the result. On the left the VAT nr in the import file. On the right the VAT number after the transformation is applied.

Replace

In an import file, you have a column called paying customer. It contains the values Yes and No. You want to import this information into Superoffice and make it visible by using the Stop sign in SuperOffice. The problem is that Yes will activate the Stop sign.

...