BEGIN{ num=split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec",arr,",") for(j=1;j<=num;j++){ key=sprintf("%02d",j) months[key]=arr[j] } } { $1=substr($1,length($1)-1)"H"substr($1,length($1)-3,2) months[substr($1,3,2)] "19" substr($1,1,2) print }