my $sql = "'XXXX-ax1-d.ett.amrs.bankofamerica.com','UAT','AMRS','AMS','','YYYY','ZZZZ',,,,"; print "$sql\n"; $sql =~ s/,(?=,)/,NULL/g; print "$sql\n";