#!/usr/bin/perl
use strict;
my $csv_add = 'add.csv';
my $csv_flex = 'flex.csv';
print "
csv_add : $csv_add
csv_flex : $csv_flex\n";
for my $filename ($csv_add,$csv_flex){
if (-e $filename){
rm_spaces($filename);
} else {
warn "$filename not found";
}
}
# remove spaces,tabs,newlines,formfeeds,cr
# and /I/0 and /T/0
sub rm_spaces {
my $filename = shift;
my $bakfile = $filename.'.bak';
rename ($filename,$bakfile)
or die "Could not rename $filename to $bakfile";
open my $fh_in, '<',$bakfile or die "Could not open $bakfile";
open my $fh_out,'>',$filename or die "Could not open $filename";
while (<$fh_in>) {
s/\s+|\/[IT]\/0//g;
print $fh_out "$_\n";
}
close $fh_in;
close $fh_out;
unlink $bakfile;
}
poj