Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Joining two files on common field

by graff (Chancellor)
on Sep 22, 2005 at 22:57 UTC ( [id://494337]=note: print w/replies, xml ) Need Help??


in reply to Joining two files on common field

Yet another way -- just a plain hash:
use strict; my %data; open(I1,"file1") or die "file1: $!" $_ = <I1>; # read column headings while (<I1>) { # get data chomp; my ($upc,$qty) = split /,/; $data{$upc} = $qty; } open(I2,"file2") or die "file2: $!" $_ = <I2>; # read column headings while (<I2>) { # get data chomp; my ($sku,$siz,$clr,$upc) = split /,/; $data{$upc} .= join ',', '', $sku, $siz, $clr; # or: $data{$upc} = join ',', $data{$upc},$sku,$siz,$clr; } for (sort keys %data) { print "$_,$data{$_}\n"; }
That's pretty brittle in a number of ways: it won't handle properly quoted fields in a CSV file (e.g. '121,MD,"Green, Kelly",87654321'); it depends rigidly on a particular ordering and quantity of columns in each file; if file2 has a upc value not found in file1, it'll print ",$sku,$siz,$clr"; if file1 has a upc value not found in file2, it'll print "$upc,$qty".

But it's simple and should do the job as you described it.

Replies are listed 'Best First'.
Re^2: Joining two files on common field
by Skeeve (Parson) on Sep 23, 2005 at 06:10 UTC
    You said: That's pretty brittle in a number of ways: ... it depends rigidly on a particular ordering and quantity of columns in each file

    So let's fix that.

    $_ = <I1>;   # read column headings
    becomes
    $_ = <I1>; # read column headings my @columns= split /,/;


    And when reading the columns, instead of
    my ($upc,$qty) = split /,/;
    and
    my ($sku,$siz,$clr,$upc) = split /,/;
    we put
    @line{@columns}= split /,/;
    (provided you have a my %line; defined)

    So in full:

    $\=~s;s*.*;q^|D9JYJ^^qq^\//\\\///^;ex;print

Log In?
Username:
Password:

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

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

    No recent polls found