Shell Programming and Scripting

Hi I'm working on a file which looks like:

00001| |XXX|ABCD|27-SEP-1983|31-DEC-2099|Name|00001|N| |31|L| | | | |25-AUG-1990

I need to change the date format from DD-MMM-YYYY to MM/DD/YYYY

So i using
cat <filename> | sed 's%-JAN-%/01/%;s%-FEB-%/02/%;s%-MAR-%/03/%;s%-APR-%/04/%;s%-MAY-%/05/%;s%-JUN-%/06/%;s%-JUL-%/07/%;s%-AUG-%/08/%;s%-SEP-%/09/%;s%-OCT-%/10/%;s%-NOV-%/11/%;s%-DEC-%/12/%;' | sed 's%|\([0-9][0-9]\)/\([0-9][0-9]\)/\([0-9][0-9][0-9][0-9]\)%|\2/\1/\3%'

Now the first sed is working perfectly fine. It is replacing all the date formats to DD/MM/YYYY but the problem is in the next sed which is working only on the first date field not the rest.

I'm getting the output as:
00001| |XXX|ABCD|08/27/1983|31/12/2099|Name|00001|N| |31|L| | | | |25/08/1990

Whereas I'm looking for the output as :
00001| |XXX|ABCD|08/27/1983|12/31/2099|Name|00001|N| |31|L| | | | |08/25/1990

Any help would be appreciated.
Thanks

A solution with awk:

Code:

awk '
BEGIN {
  FS=OFS="|"
  a="JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC"
  split(a,m,",")
  for(i=1;i<13;i++)
    n[m[i]]=i
}
{split($5,d,"-");$5=sprintf("%02d/%s/%s",n[d[2]],d[1],d[3])}
{split($6,d,"-");$6=sprintf("%02d/%s/%s",n[d[2]],d[1],d[3])}
{split($17,d,"-");$17=sprintf("%02d/%s/%s",n[d[2]],d[1],d[3])}
{print}' file

Use nawk or /usr/xpg4/bin/awk on Solaris.

Regards

It works. Thanks a lot.