Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Re: How can I read a file that is comma delimited but includes a comma in the string?

by Anonymous Monk
on May 28, 2003 at 00:00 UTC ( #261141=note: print w/ replies, xml ) Need Help??


in reply to Re: How can I read a file that is comma delimited but includes a comma in the string?
in thread How can I read a file that is comma delimited but includes a comma in the string?

if all fields were in double quotes then how could I include it and not print the quotes?


Comment on Re: Re: How can I read a file that is comma delimited but includes a comma in the string?
Re: Re: Re: How can I read a file that is comma delimited but includes a comma in the string?
by arturo (Vicar) on May 28, 2003 at 00:05 UTC

    The Perl module Text::CSV can be really helpful here, since it's designed to handle things like quotes for you.

    If not P, what? Q maybe?
    "Sidney Morgenbesser"

Re: Re: Re: How can I read a file that is comma delimited but includes a comma in the string?
by Ovid (Cardinal) on May 28, 2003 at 00:13 UTC

    Directly from the POD of Text::CSV_XS:

    require Text::CSV_XS; my $csv = Text::CSV_XS->new; my $column = ''; my $sample_input_string = '"I said, ""Hi!""",Yes,"",2.34,,"1.09" +'; if ($csv->parse($sample_input_string)) { my @field = $csv->fields; my $count = 0; for $column (@field) { print ++$count, " => ", $column, "\n"; } print "\n"; } else { my $err = $csv->error_input; print "parse() failed on argument: ", $err, "\n"; } my @sample_input_fields = ('You said, "Hello!"', 5.67, 'Surely', '', '3.14159'); if ($csv->combine(@sample_input_fields)) { my $string = $csv->string; print $string, "\n"; } else { my $err = $csv->error_input; print "combine() failed on argument: ", $err, "\n"; }

    Cheers,
    Ovid

    New address of my CGI Course.
    Silence is Evil (feel free to copy and distribute widely - note copyright text)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2014-09-20 04:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (153 votes), past polls