CSV file import problem

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

adrian_d
Posts: 44
Joined: Wed Jan 29, 2014 6:08 am

CSV file import problem

Postby adrian_d » Thu Mar 17, 2016 7:13 am

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
Attachments
csv file sample.csv
(1.1 KiB) Downloaded 325 times

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: CSV file import problem

Postby EViews Steve » Thu Mar 17, 2016 8:40 am

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 3756 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

adrian_d
Posts: 44
Joined: Wed Jan 29, 2014 6:08 am

Re: CSV file import problem

Postby adrian_d » Thu Mar 17, 2016 8:43 am

Wow, thank you for such a quick and precise answer!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests