I have a text file in the format: 01/04/2007,field1,field2,field3 01/03/2007,field1,field2,field3 12/30/2006,field1,field2,field3 etc...I need to sort by date, but the new dates in 2007 are placed first in the sort algorithm. How can I sort by the entire date in the format above?
This works on my admittedly small test set: :%!sort -k3 -t/ -- .