Shell Programming and Scripting

a2p -F"|" awk_script > perl_script
chmod 777 perl_script
./perl_script input_file.txt

#!/usr/bin/perl
eval 'exec /usr/bin/perl -S $0 ${1+"$@"}'
    if $running_under_some_shell;
                        # this emulates #! processing on NIH machines.
                        # (remove #! line above if indigestible)

eval '$'.$1.'$2;' while $ARGV[0] =~ /^([A-Za-z_0-9]+=)(.*)/ && shift;
                        # process any FOO=bar switches

$[ = 1;                 # set array base to 1
$FS = '\|';             # field separator from -F switch
$, = ' ';               # set output field separator
$\ = "\n";              # set output record separator

while (<>) {
    chomp;      # strip record separator
    @Fld = split(/[|\n]/, $_, -1);

    $, = '|';
    @d1 = split(/-/, $Fld[6], -1);
    @d2 = split(/-/, $Fld[7], -1);
    $Fld[6] = sprintf('%04d-%02d-%02d', $d1[3], $d1[1], $d1[2]);
    $Fld[7] = sprintf('%04d-%02d-%02d', $d2[3], $d2[1], $d2[2]);
    print join($,,@Fld);
}