Illegal date when importing txt file

[patrice]

Hello,

When trying to import this txt file, I have this error message: Illegal date ?.

Here my code:

Code: Select all

wfcreate m 2010 2025 import(type=txt, resize) "c:\temp\eviews_issue.txt" ftype=ascii rectype=crlf skip=0 fieldtype=delimited custom=";" colhead=1 namepos=custom eoltype=pad badfield=NA @smpl @all

If I remove the last row, it's working fine.

I tested this under all these version, with same bug:
- Eviews 13 Jun 20 2024 build
- Eviews 14 Dec 26 2024 build

Thanks for your help.

[startz]

If you could post that last row in the text file there's better chance someone might catch what's wrong.

[patrice]

The attached txt file in the ticket contains this row, I have the error message using this txt file.

[startz]

If it helps, I get the same error you do. But if I use File/Open it appears to work. No idea why.

[patrice]

Thanks, but unfortunatly I'm using this in an eviews program.

[EViews Gareth]

You're trying to import panel data (I think?) into a dated workfile, and it is failing.

Rather than create the workfile and then import, just open the text file as a new workfile.

Code: Select all

wfopen "c:\temp\eviews_issue.txt" ftype=ascii rectype=crlf skip=0 fieldtype=delimited custom=";" colhead=1 namepos=custom eoltype=pad badfield=NA @smpl @all

Then manipulate it after opening.

[startz]

Some of the dates look like 201001. Is there a good way to handle that?

[patrice]

You're trying to import panel data (I think?) into a dated workfile, and it is failing.

Rather than create the workfile and then import, just open the text file as a new workfile.

Code: Select all

wfopen "c:\temp\eviews_issue.txt" ftype=ascii rectype=crlf skip=0 fieldtype=delimited custom=";" colhead=1 namepos=custom eoltype=pad badfield=NA @smpl @all

Then manipulate it after opening.

Thanks for this, but do-you know why there is this error message ? is-it a eviews bug ? (It's not an easy task to change my program)

[EViews Gareth]

The last line of your file has no date.