bigbalbossa
Programmer
Alright folks...i didn't think this would be too difficult, but it's turning into quite a chore.
I have 7GB pipe delimited file that seems to have line feeds in the wrong place. There should be 18 pipes per line, however, when i run a script that does a count i get:
There are 1 line(s) with 12 pipes
There are 24 line(s) with 2 pipes
There are 6 line(s) with 20 pipes
There are 3 line(s) with 14 pipes
There are 4 line(s) with 4 pipes
There are 45873912 line(s) with 18 pipes
There are 2 line(s) with 0 pipes
There are 23 line(s) with 16 pipes
There are 126 line(s) with 19 pipes
There are 1 line(s) with 13 pipes
There are 1 line(s) with 5 pipes
Is there a way to remove all CRLF's, count 18 pipes, then add a CRLF?
Any ideas are much appreciated.
I have 7GB pipe delimited file that seems to have line feeds in the wrong place. There should be 18 pipes per line, however, when i run a script that does a count i get:
There are 1 line(s) with 12 pipes
There are 24 line(s) with 2 pipes
There are 6 line(s) with 20 pipes
There are 3 line(s) with 14 pipes
There are 4 line(s) with 4 pipes
There are 45873912 line(s) with 18 pipes
There are 2 line(s) with 0 pipes
There are 23 line(s) with 16 pipes
There are 126 line(s) with 19 pipes
There are 1 line(s) with 13 pipes
There are 1 line(s) with 5 pipes
Is there a way to remove all CRLF's, count 18 pipes, then add a CRLF?
Any ideas are much appreciated.
