Shell Programming and Scripting

I have a CSV file which I have to sort it by a field with DDMMYYYY format, since I'm not a unix specialist, how is the easiest way to do this?

Sample data
30062008,432120,A,5001,A,201,Z ,2,MXN
31092008,432121,B,4001,B,101,Z ,2,MXN
05112008,432122,C,2001,C,51,Z ,2,MXN
30102008,432124,D,1001,D,31,Z ,2,MXN
20022008,432125,E,601,E,16,Z ,2,MXN
31042008,432126,F,401,F,6,Z ,2,MXN
30072008,432127,G,101,G,1,Z ,2,MXN
07022008,432128,A,5002,A,202,Z ,2,MXN
11012008,432129,B,4002,B,102,Z ,2,MXN

This should work for your CVS file.

Code:

sort -n -k1.3,1.4 -k2.1,2.2 file.cvs

Please don't post homeworks and please read the forum rules.

Code:

awk 'BEGIN{FS=","}
{
temp=sprintf("%s%s%s",substr($1,5),substr($1,3,2),substr($1,1,2))
print temp","$0
}' file | sort -n | cut -d"," -f2,3,4,5,6,7,8,9,10