CMDBuild Forum

A lot of false line breaks in data stored in our database

Hi,

I’ve just started my new role as application administrator of our CMDBuild 3.4.b environment. And I’ve been trying to export data from our list of applications. But the CSV file that is created is very dirty. A lot of line breaks, single quotation marks, and characters that disturb a good data import in other systems. Probably they come from pasting in data from Excel and other MS Office products.

Does anyone of you people have a tool/script to get rid of this from our database?

Kind regards,

Frans Erich