BEGIN { my $pgm = <<'EOT'; my @mon = qw( Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ); my %mons; my $i; $mons{$_} = ++$i for @mon; my $mon_str = join("|", @mon); my $mon_re = qr/$mon_str/; s/(^|\|)($mon_re)\s{1,2}(\d{1,2})\s(\d{4})\s\s?(\d\d?):(\d\d):(\d\d):(\d{3})([AP])M(\||$)/ $1. sprintf("%04d-%02d-%02d %02d:%02d:%02d.%03d", $4, $mons{$2}, $3, ( $9 eq "P" && $5 < 12) ? $5 + 12 : ( $9 eq 'A' && $5 == 12 ) ? 0 : $5, $6, $7, $8). $10 /eg; EOT sub fix_bcp_file { my ($file) = @_; system($^X, "-pi", "-e", $pgm, $file); } }