join 3 files by first Column with awk ?

Posted by noinflection on Stack Overflow See other posts from Stack Overflow or by noinflection
Published on 2010-05-12T04:00:07Z Indexed on 2010/05/12 4:14 UTC
Read the original article Hit count: 215

Filed under:
|
|
|

i have three similar files, they are all like this:

File A

ID1 Value1a
ID2 Value2a
  .
  .
  .
IDN Value2n

and i want an output like this

Output

ID1 Value1a Value1b Value1c
ID2 Value2a Value2b Value2c
.....
IDN ValueNa ValueNb ValueNc

Looking to the first line, i want value1A to be the value of id1 in fileA, value1B the value of id1 in fileB, and so on which each field and each line. I thougth it like a sql join. I've tried several things but none of them where even close.

© Stack Overflow or respective owner

Related posts about bash

Related posts about awk