I have years worth of data saved as tab separated values, unfortunately, each file also has the following header, that I can not figure out how to work with. No matter what I have tried I can not get the following rows of data to import, it always gives an error of: "an attribute is specified for column 1 but column 1 does not exist" and fails to recognize the dozens of columns of data below the header. Manually removing the header enables the import wizard to work properly, but removing that manually is not really an option for thousands of datafiles.
Anyone have a good idea how to get past this issue? I was planning on looping through the files in the folder structure, extracting the unit SN,PN, Date,Time from either the header or the file name, and combining it all together into one set of data to look at the population over time, but I am stuck at ostensibly the simplest part of the whole thing, how to automate the import of the text file.
Time: 7:57 AM
UUT P/N: 1-111-11
UUT S/N: 113541-1234
FTP Revision -
ATP Revision A
Medium Flowmeter Part Number: XXXXXXXXXXXXXXXXX
Medium Flowmeter Serial Number: 4546544546
Large Flowmeter Part Number: XXXXXXXXXXXXXXXXX
Large Flowmeter Serial Number: 1324564321
ATE Serial Number: 00