bad csv file

[#1]

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?

[#2]

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.

[#3]

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 ';');