Attempting to use FileSystemObject for the first time and running into trouble. I am using the code below on a file (sent to me) and I cannot figure out why it won't work. Seems the AtEndOfStream flag is set to True as soon as the file is read, instead of after all of the lines are processed. Not sure how to handle. Can anyone point me in the right direction? I have attached the sample file as well as the code
I should mention, I created my own text file and the code worked, so I believe the txt file I received has some issues, but I cannot seem to figure out what the issues are or how to fix them. I did my own searches for ^13 using MS Word and found CR's at the end of every line, however the code below didn't see the individual lines.
I couldn't find anywhere on the internet that specifically told me what the AtEndOfStream property was looking for (CR, LF, ???) so I am puzzled.
Bookmarks