What is a good way to edit CSV files in Ubuntu?
The files look something like this:
This,is,data,with,a,header 2,2,3,4,, 1,,3,,6,6 ,5,3,5,5,6 1,2,,,, 1,2,3,4,8,6 1,,9,,5,9 -1,,3,4,5,6 1,2,0,4,5,6
I've been using OpenOffice, but it takes about 5 clicks to turn off the default behaviour of quoting all of the fields.
I'd like to find something lightweight and easy to use that will allow inserting/deleting data, and column-based sorting.