#!/usr/bin/perl --
use strict; use warnings;
use Text::CSV;
use Data::Dump;

open my $io, '<', \q{
"My Company","Gavin","Henry ","ghenry@ghenry.co.uk"," 1.00"
};

my $csv = Text::CSV->new( { binary => 1, eol => $/ } );

while ( my $row = $csv->getline($io) ) {
    my @fields = @$row;
    next unless $fields[4];
    dd \@fields;
    $fields[4] =~ s/\s+//g;
    print $fields[4], "\n";
    dd \@fields;
}
__END__
["My Company", "Gavin", "Henry ", "ghenry\@ghenry.co.uk", " 1.00"]
1.00
["My Company", "Gavin", "Henry ", "ghenry\@ghenry.co.uk", "1.00"]