I have a text file that contains randomly distributed ASCII 26 characters that I want to process using a VB app.
VB sees ASCII 26 as EOF and will not process the file beyond the first EOF it hits.
I have no control over the file contents because the file is generated by a customer who is not responsive to requests that require programming changes.
The complete file can be loaded by text and word processors like Notepad, Textpad, Wordpad and Word.
Due to the random occurrence of the characters, I cannot use a macro based on consistent mouse movements and keystrokes. A Word VBA macro won’t work because Word sees the original file as Unicode UTF-8 encoded and when the file is saved as plain text, Word eliminates other control characters (e.g. ASCII 12 page breaks) that must be retained.
Does anyone have any suggestions as to how I might resolve this dilemma within a VB app, even if it involves launching another app to clean the EOFs from the file?