Re: Converting comma-delimited data to tab-delimited

From: Randall Perry <rgp(at)systame(dot)com>
To: <rgp(at)systame(dot)com>
Subject: Re: Converting comma-delimited data to tab-delimited
Date: 2002-03-31 22:43:56
Message-ID: 20020401001711.MJYJ27903.imf24bis.bellsouth.net@[216.78.241.154]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry, that last code didn't work. This does:

use Text::CSV_XS;

my $csv = Text::CSV_XS->new();

while (<>) {
$csv->parse($_);
print join("\t", $csv->fields) . "\n";
}

> Thanks, I needed that.
>
> For the benefit of anyone else who needs this feature, I've corrected some
> errors in your code, and also used the latest version of the module:
> Text::CSV_XS.
>
> Here's the new code:
>
>
> #!/usr/local/bin/perl -I
>
> use Text::CSV_XS;
>
> my $csv = Text::CSV->new;
> while (<>) {
> chomp;
> $csv->parse($_);
> print join("\t", $csv->columns), "\n";
> }
>
>
> Old code:
>
>>
>> use Text::CSV;
>>
>> my $t = Text::CSV->new;
>> while (<>) {
>> chomp;
>> csv->parse($_);
>> print join("\t", $csv->columns), "\n";
>> }
>>
>

--
Randy Perry
sysTame
Mac Consulting/Sales

phn 561.589.6449
mobile email help(at)systame(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vernon Wu 2002-04-01 01:22:57 Using inheritance - a table design question
Previous Message Vernon Wu 2002-03-31 21:36:47 Use Inherrtance or not, a table desing question