1

I need to modify a csv file by skipping the first line and removing odd lines.

csv file:

name,tags,time,mean
server_1,a,2015-10-24T11:45:27.869918Z,620023.5521262008
name,tags,time,mean
server_2,b,2015-10-24T11:45:27.869918Z,0
name,tags,time,mean
server_3,c,2015-10-24T11:45:27.869918Z,0
name,tags,time,mean
server_4,d,2015-10-24T11:45:27.869918Z,66.16323731138544

This thread explains how to remove odd lines. But I don't know how to skip the first line and print it out like below:

name,tags,time,mean
server_1,a,2015-10-24T11:45:27.869918Z,620023.5521262008
server_2,b,2015-10-24T11:45:27.869918Z,0
server_3,c,2015-10-24T11:45:27.869918Z,0
server_4,d,2015-10-24T11:45:27.869918Z,66.16323731138544

Thanks!

Community
  • 1
  • 1
hossein
  • 336
  • 3
  • 11
  • 23

2 Answers2

2

Try this:

awk 'NR%2==0 || NR==1' infile > outfile
F. Knorr
  • 3,045
  • 15
  • 22
1

you can use awk

awk 'NR==1 || !(NR%2)' file

or gnu-sed

sed -n '1p; 2~2p' file

or

sed '3~2d' file
Jose Ricardo Bustos M.
  • 8,016
  • 6
  • 40
  • 62