I have a comma-delimited giant file that was exported from a database. The file has this format
Date,n1,n2,n3,n4,n5,n6,color,type,reference
10-Jan-2000,344,13,21,2,55,3,"rose garden" ,3444,32
11-Jan-2000,324,3,1,21,5,23,"space green fox" ,3444,11
12-Jan-2000,34,23,31,22,5,34,"bourbon mars" ,3444,88
Notice that the color field is surrounded by quotes and has a space at the end. Don't ask me why.
I would like to end with a file that is just this:
n1,n2,n3,n4,n5,n6
344,13,21,2,55,3
324,3,1,21,5,23
34,23,31,22,5,34
what magic command should I type on terminal to get rid of the date, color, type and reference on all lines of that txt file?
cut -d, -f2-7
– Stéphane Chazelas Jan 18 '14 at 18:22