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
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.
...