I'm attempting to sort a csv on my machine, but I seem to be erasing the contents each time I use the sort command. I've basically created a copy of my csv lacking the first row:
sed '1d' original.csv > newcopy.csv
To confirm that my new copy exists lacking the first row I can check with head:
head 1 newcopy.csv
Sure enough, it finds my file and shows me the original second now (now first row). My csv consists of numerous values seperated by commas:
Jonathan Sampson,,,,
[email protected],,,GA,United States,,
Jane Doe,Mrs,,,
[email protected],,,
FL,United States,32501,
As indicated above, some fields are empty. I want to sort based upon the email address field, which is either 4, or 5 - depending on whether the sort command uses a zero-based index. So I'm trying the following:
sort -t, +4 -5 newcopy.csv > newcopy.csv
So I'm using -t, to indicate that my fields are terminated by the comma, rather than a space. I'm not sure if +4 -5 actually sorts on the email field or not - I could use some help here. And then newcopy.csv > newcopy.csv to overwrite the original file with new sort results.
After I do this, if I try to read in the first line:
head 1 newcopy.csv
I get the following error:
head: cannot open `1' for reading: No such file or directory == newcopy.csv <==
Sure enough, if I check my directory the file is now empty, and 0 bytes.