EOF as part of last Line

echovue · December 5th, 2005, 02:51 PM

Has anyone ever seen a csv file where the EOF character is included in the last record? I have this problem where is give and EOF error when the attempt is made to read the last record. Anyone have any ideas around it, aside from inserting a blank dummy record at end before I read each line in?

Thanks

Mike

Mike
EchoVue.com

mmcdonal · December 5th, 2005, 04:06 PM

Do Until rs.EOF = True

Loop

That should work.

I have seen that character inserted in all types of files. It carries into Excel as an unrecognized character, and if you transfer the spreadsheet, it even comes in as a blank record, except for the first field.

If you put a condition on the logic to account for this, then it should work.

HTH

mmcdonal

mmcdonal · December 5th, 2005, 04:26 PM

Actually, if you are parsing a csv file, then you are looking for the EndOfStream, so I am not sure why this is causing a problem.

I would use a text reading function, and possibly delete the last line in each file???

I usually read the text files, rather than use EOF, I use AtEndOfStream, and don't have this problem.

More facts, more solutions. Sorry for the malformed reply.

mmcdonal

echovue · December 5th, 2005, 08:57 PM

Doh! Sorry, I only found out about TextStreams a month ago, on an unrelated project, and I guess didn't implement them properly in this one - This would explain some of the EOF errors as well

Please forgive my ignorance!

Thanks

Mike

Mike
EchoVue.com

mmcdonal · December 7th, 2005, 08:49 AM

If you are using text streams, they will see that end of record character as a record, but it won't have the proper fields, of course.

mmcdonal