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 exploiting the Monastery: (18)
As of 2015-07-02 10:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (33 votes), past polls