Hi, I have approximately 3000 txt files of the format attached. I'm looking for the simplest way to convert them into one .csv for import into a DB. The field length is determined by the dashes on row 7 (some fields fluctuate in length), the rows before row 7 can be discarded.
I have to believe their is an easy way. A script that could read the first file, delimit according to row 7, export into a csv and then read the next file.