I have an output flat file received from a vendor. In order to load into a table, I need one line per ID/note. As you can see, there are misc carriage returns, line feeds and blank lines. The beginning of each line/record will always be numbers but total number digits could vary. Is there a way to run a DOS command
to fix this formatting?
I found a way to remove the blank lines and also to remove all CR/LF which gives me one large text file.
Any thoughts, direction, greatly appreciated.