Page 1 of 1

CSV file import problem

Posted: Thu Mar 17, 2016 7:13 am
by adrian_d
Hi there,

I have a problem with reading a csv file into eviews. I don't know what is wrong with this file, Excel reads it, but Eviews cannot. Can you verify this please?

thanks
adrian

Re: CSV file import problem

Posted: Thu Mar 17, 2016 8:40 am
by EViews Steve
The reason EViews is treating your file as binary is because the CSV file is currently in Unicode (UTF-16 to be exact) format. If you open the CSV file in Notepad, then go to the Save As dialog, you'll see that the Encoding is "Unicode":
SaveAs.png
SaveAs.png (7.14 KiB) Viewed 3758 times
EViews doesn't currently handle Unicode files so to import this data you'll have to use ANSI format instead. If you re-save the document in ANSI format, then do the import, EViews should recognize it properly.

Obviously it would be nicer if EViews supported the various unicode text formats automatically during an import, so I'll look into adding this support -- but for now this is the workaround.

Steve

Re: CSV file import problem

Posted: Thu Mar 17, 2016 8:43 am
by adrian_d
Wow, thank you for such a quick and precise answer!