How can I concatenate two .csv files in unix with header by first grepping on creation time
Posted on 2010-09-01
I have some .csv files in the directory "/v/region/na/appl/qatools/util/data/reports/automation_framework"
The .csv files have been created from corresponding .xls files through
mv Int_Res1.xls Int_Res1.csv
the .csv files have the structure like below
header1 header2 header3
value1 value2 value3
I need to concatenate the .csv files into a final_res.csv file by first grepping on files beginning with "Int_Res" in the dir "/v/region/na/appl/qatools/util/data/reports/automation_framework, then putting the file which was created first in the final_res.csv along with header, then appending the next created file but stripping off the header row which is row 0 and so on.
How can I do this in Unix?