Remove header row from CSV's
I have a directory with circa 3k CSV files containing various data, I need
to collate these into a single file at some point, but first I need to
remove all of the header rows from each file.
Usually for this I would collate the files, and then simply open in Excel,
and filter to the header rows before deleting them all. Unfortunately,
these sum to something around 9M rows, and Excel doesn't like that...
Can anybody think of a way around this? Preferably some sort of batch
script that will run through all files in a directory.
Thanks in advance,
A.
No comments:
Post a Comment