Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Re: combining 2 files with a comon field

by mattk (Pilgrim)
on May 18, 2005 at 13:03 UTC ( #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?

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2023-06-09 10:28 GMT
Find Nodes?
    Voting Booth?
    How often do you go to conferences?

    Results (35 votes). Check out past polls.