I am reading text files line by line using the fso.OpenTextFile / Textstream.Readline method to get row counts, make some line amendments and then write the lines back out to a new file.
The issue I have is that I often get text files with embedded linefeeds in some rows which is causing .Readline to end at that point and then start reading the rest of the line as a new line.
Is there any change or addition can add to this method so it will ignore any embedded linefeeds and correctly read until the end of the line?
The other method I was experimenting with was ADODB.stream, and with that .ReadText(adReadLine) works fine and seems to ignore the embedded linefeeds, but I've found ADODB to be slower the larger the files get.
Unable to upload a workbook at the moment, but hopefully that shouldn't matter in this case.
Bookmarks