Date Validation:

Shell Programming and Scripting
1

Hi
I have below file with 3 rd column as date ....i want to make 3 column to mm/dd/yyyy .
in the below file 2 row date is like 1/23/1994 so i want to append '0'
to month i,e. 01/23/1994 and in the 3 row date is like 6/4/1994 ---so i want this to 06/04/1994

Source:
E116005/29/19930E001E000
E12201/23/19940E001E003
E10406/4/19940E001E003

Result:
E116012/29/19930E001E000
E122001/23/19940E001E003
E104006/04/19940E001E003

can any one help me ......

2

If you have ksh93

while read line
do
   col2=${line:5:((${#line}-14))}
   printf "%s%(%m/%d/%Y)T%s\n" ${line:0:5} $col2 ${line: -9}
done < yourfile

outputs

E116005/29/19930E001E000
E122001/23/19940E001E003
E104006/04/19940E001E003