http://www.perlmonks.org?node_id=846492

mellon85 has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to use a tab-delimited CSV file with DBD::CSV but some fields contain spaces and the driver uses them as column separator scrambling all the columns.

my $csvh = DBI->connect("DBI:CSV:f_dir=.;csv_sep_char=\t;csv_eol=\n;") or die($DBI::errstr); $csvh->{'csv_tables'}->{'csv'} = { 'file' => file.csv };