@dates = `mysqlshow --password=\'xxxxxxx\' pzbg001`;
shift @dates;
shift @dates;
shift @dates;
shift @dates;
pop @dates;

foreach $date(@dates){
        chomp $date;
        $date =~ s/ //g;
        $date =~ s/\|//g;
        $date =~ s/\-//g;
        $date =~ s/Tables//g;
        $date =~ s/\+//g;
...