topic bad csv file in QlikView

bad csv file

Mon, 17 May 2010 17:04:22 GMT

Hi all,

i'm writing a qv example: i must write a csv file and than read it, all in qv script. I can create the file, but when i open it with excel, the first characters in the "A1" cell are "ï»¿", and than the correct char. That cause a qlikview error when i read that file, infact the name of the first column of the file is changed from "First" to "ï»¿First".

Any suggestion?

bad csv file

Mon, 17 May 2010 17:15:47 GMT

Your csv file is probably using the UTF-8 unicode encoding.

I dont think Excel supports UTF-8 csv files.Open and Save with excel will brake the file most likely.

If you only need western characters, then maybe you can save the file with the ansi encoding and things might work.

bad csv file

Wed, 19 May 2010 09:09:21 GMT

Hi DPN,

thanks for your reply. I don't think the problem is the UTF-8 charset becouse I use the following options in the script when i save the csv:

Store * from TEST into .\DATA\test.csv (ansi,txt,embedded labels,delimiter is ';');