Every time the database is exported to a CSV the Path identifier in cell A1 is preceded by the following characters Path. Weird characters has to be deleted in order to get a successful import from CSV.
That’s the UTF-8 Byte Order Marker. Excel, which I presume you’re using to open it, has horrible UTF-8 support, from what I read online.
But, the problem is still on our side- we require the BOM for UTF-8, when the general convention is that it should be optional. But still, it’s allowed, and most text editors won’t mind it.
Regards,
I’m using Open Office Spreadsheet. Switching to Unicode UTF-8 solved the problem. Thanks