So, I have this problem:
I have a set of large files that are output from a database.
The column delimiter is 'Ç'.
There _should_ be 38 'Ç's per line -- ie 38 columns in the original table. Sometimes there are not. There may be, say, 36 'Ç's on a particular line.
What I want to do is, write a macro that Checks each line in the file to see if it has 38 'Ç's. If it does not, delete the line or move it into a different file.
Is there an easy and fast way to do this?
|
|