use strict;
use warnings;
use Tie::File;

foreach my $x (@ARGV) {
    tie my @f, 'Tie::File', $x or die "Could not tie $x: $!\n";
    for (@f) {
        s/^\|/\\N\|/;
        s/\|\s*$/\|\\N/;
        s/\|\s*\|/\|\\N\|/g;
        s/\|\.\s*\|/\|\\N\|/g;
        s/\|\s+/\|/g;
        s/\s+\|/\|/g;
        s/(\d{2}:\d{2}:\d{2})\.\d+/$1/g;
        s/(\d{5})-(?:\d{1,4}|\s+)/$1/;
    }
}