Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: CSV Update Issues

by Tux (Canon)
on May 12, 2015 at 10:51 UTC ( [id://1126405]=note: print w/replies, xml ) Need Help??


in reply to CSV Update Issues

PLEASE rewrite to using hash-attributes connect instead of DSN!

new scroll down to quote_space

quote_space

my $csv = Text::CSV_XS->new ({ quote_space => 1 }); $csv->quote_space (0); my $f = $csv->quote_space;

By default, a space in a field would trigger quotation. As no rule exists this to be forced in CSV, nor any for the opposite, the default is true for safety. You can exclude the space from this trigger by setting this attribute to 0.

Your connect will need to add

my $dbh = DBI->connect ("dbi:CSV:", undef, undef, { # ...... csv_quote_space => 0, });

Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1126405]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2024-04-20 03:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found