Shell Programming and Scripting

Hi all,

i need to remove the header for all the files which is ending with .csv and append into one file

example,

Code:

test1.csv
test2.csv
test3.csv

i tried with the below command,

Code:

sed '1d' test*.csv> appendnew.csv

but it deletes only the first file header. and appending all the files

Thanks,
baski

Code:

$ for i in test*.csv; do sed '1d' $i >> append.csv; done

A possible solution :

Code:

awk 'FNR>1' test*.csv> appendnew.csv

Jean-Pierre.

Code:

awk 'FNR>1{print}' *.csv > out_file

--ahamed

Are you sure that its appending all the test*.csv files to appendnew.csv..? Try with >> instead of >

Thanks for all your replies,

i m just expanding my query,

i can able to delete and append by using the below comman,

Code:

awk 'FNR>1{print}' *.csv >> out_file

and i aslo need some particular columns in the csv files , so i tried with this

Code:

awk -F"," -v OFS=',' '{print $1, $2,$8}' *csv >> outfile1

above also working fine but i need to merge it into single awk command and also need to sort the cloumns on w.r.t column $2
pls help me on this

thanks,
Baski

Code:

awk -F"," -v OFS="," 'FNR>1{print $1,$2,$8}' csv >> outfile1

--ahamed