Import error in csv file

Hi! Is there any news in this topic? We have payed for the component and for the support! Thanks! Antal

kisznera I have an excel file which I saved in csv format. The excel in default case use ; as a delimitter.

IMHO, you should be able to set another default delimiter. Either in Excel itself, or in Windows control panel -> Region(al) ... Please, search the net for a detailed tutorial.

When I try to import the csv file the pasing of the file was not correct. The cobalt hasn't realise the columns correctly. After I changed all ; to , in notepad++ the parsing method of the cobalt worked correctly and the import was OK. Please check the parsing of csv fikles.

Thanks for your report!
I remember there was an issue in the past with ; SEMICOLON, but I thought it has been fixed a long time ago.
I have to admit that I always used , COMMA. So, I can't really confirm your issue.

Hi,

We have several , (comma) in the texts of the excel file so we prefer exporting to ; separeted csv file. Of cource I tried to change the default delimitter, but in some cases it doeasn't help in word 2010.

Whay cannot you simply save files from Excel with commas?

Hi,

We have several , (comma) in the texts of the excel file so we prefer exporting to ; separeted csv file. Of cource I tried to change the default delimitter, but in some cases it doeasn't help in word 2010.

That means we store datas with several comas in the texts (adresses, names eg.). In the latest excel vbersions it is not possible to change the separator.

I know you may have coma in texts, but you can delimit text with "