Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: combining 2 files with a comon field

by mattk (Pilgrim)
on May 18, 2005 at 13:03 UTC ( [id://458182]=note: print w/replies, xml ) Need Help??


in reply to combining 2 files with a comon field

This is assuming the files have the same amount of lines:
use IO::File; $f1 = new IO::File "< file1"; $f2 = new IO::File "< file2"; $f3 = new IO::File "> file3"; while (my ($c1, $c2) = map { m/^.*?\|(.*)\|$/ } ($f1->getline, $f2->ge +tline)) { print $f3 "A$.|$c1|$c2|\n"; last if eof; }
Reads in one line from each file, extracts the column values using map and a regex, and then prints out a new line containing both column values, plus a header made from $.

Replies are listed 'Best First'.
Re^2: combining 2 files with a comon field
by jhourcle (Prior) on May 18, 2005 at 13:57 UTC

    If we're going with that assumption (same number of lines, and the keys are in the same order), then it's a one liner in unix shell:

    paste  -d\| file1 file2 | cut -d\| -f1,2,5- > file3

    I think I prefer jmcnamara's solution with join, though, as it's more forgiving of bad input.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (5)
As of 2024-03-29 10:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found