On 6/8/07, Gyepi SAM <[EMAIL PROTECTED]> wrote:
> On Fri, Jun 08, 2007 at 03:26:56PM -0400, Alex Brelsfoard wrote:
> > I have a CSV file where each line may NOT have the same number of fields.
> > One item per line.
>
> xSV is line oriented: as long as each line is well formed it should be parsed
> correctly. Making sense of the data may be more difficult though.
Yup.
> > But occasionally a field in an item will have one or more newlines in it.
> > How can I break this up correctly?
>
> Embedded newlines are OK as long as the field is quoted. However, not all
> tools will parse the field correctly. Last time I checked, Text::CSV and
> Text::CSV_XS do not. I suspect Text::xSV will be better behaved. There are
> other, non Perl, tools that should work fine as well.
I had thought that Text::CSV did handle that case, but I just checked
and it does not. :-(
Text::xSV does this correctly, though not speedily. Here is sample code:
use strict;
use Text::xSV;
my $csv = Text::xSV->new(
filename => "foo.csv",
row_size_warning => 0, # Stop warnings for variable size rows.
);
while (my @row = $csv->get_row()) {
# Do something here.
}
Cheers,
Ben
_______________________________________________
Boston-pm mailing list
Boston-pm@mail.pm.org
http://mail.pm.org/mailman/listinfo/boston-pm
