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
CSV file import problem
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
CSV file import problem
- 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
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":
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
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
Wow, thank you for such a quick and precise answer!
Who is online
Users browsing this forum: No registered users and 2 guests
