...
This article contains Tips & Tricks on the use of transformations in Nebula 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.com
More info on import transformations
More info on export transformations
...
Another Replace transform can be used in case you have a file with empty fields in the import file.
For instance, you have a column Our contact which you want to import. But not all fields in this column are filled in.
You can use the Replace transform where you choose to leave the first field empty and fill the second filed field with an associate from SuperOffice to be used as our contact. See the example below.
...
Besides formatting text values to upper or lower case, among others, we have now also introduced a new format option called Trim. This will remove all leading and trailing white -space spaces from the value in the fields.
...