#!/bin/csh

awk -F, '{split($4,month,"-");\
 if(month[2]=="Jan"){ print $1","$2","$3",01-"month[1]"-"month[3]}\
 else if(month[2]=="Feb"){print $1","$2","$3",02-"month[1]"-"month[3]}\
 else if(month[2]=="Mar"){print $1","$2","$3",03-"month[1]"-"month[3]}\
 else if(month[2]=="Apr"){print $1","$2","$3",04-"month[1]"-"month[3]}\
 else if(month[2]=="May"){print $1","$2","$3",05-"month[1]"-"month[3]}\
 else if(month[2]=="Jun"){print $1","$2","$3",06-"month[1]"-"month[3]}\
 else if(month[2]=="Jul"){print $1","$2","$3",07-"month[1]"-"month[3]}\
 else if(month[2]=="Aug"){print $1","$2","$3",08-"month[1]"-"month[3]}\
 else if(month[2]=="Sep") {print $1","$2","$3",09-"month[1]"-"month[3]}\
 else if(month[2]=="Oct") {print $1","$2","$3",10-"month[1]"-"month[3]}\
 else if(month[2]=="Nov") {print $1","$2","$3",11-"month[1]"-"month[3]}\
 else if(month[2]=="Dec") {print $1","$2","$3",12-"month[1]"-"month[3]}}' Orders.csv