UNIX for Dummies Questions & Answers

Hi,

File1.txt(tab seperated)
id val1 val2
1 abc q,w,e,r,t
2 cde l,m,n,o
...

file2.txt(csv format)
id .. .. .. .. .. .. .. ..
1 .. .. .. .. .. .. .. ..
2 .. .. .. .. .. .. .. ..
3 .. .. .. .. .. .. .. ..

Now i want to the following,
seach by "id" from file1.txt in file2.txt and then whereever it finds id in file2.txt,appned the val1 and val2 field to the existing line of file2.txt at the end.
So the final output would look like this.

file3.txt(csv format)
id .. .. .. .. .. .. .. .. val1 val2
1 .. .. .. .. .. .. .. .. abc q,w,e,r,t
2 .. .. .. .. .. .. .. .. cde l,m,n,o
3 .. .. .. .. .. .. .. ..


thanks.

Code:

root@isau02:/data/tmp/testfeld> cat file1
id      val1    val2
1       abc     q,w,e,r,t
2       cde     l,m,n,o
root@isau02:/data/tmp/testfeld> cat file2
id .. .. .. .. .. .. .. ..
1 .. .. .. .. .. .. .. ..
2 .. .. .. .. .. .. .. ..
root@isau02:/data/tmp/testfeld> join -1 1 -2 1 -o 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 1.2 1.3 file1 file2
id .. .. .. .. .. .. .. .. val1 val2
1 .. .. .. .. .. .. .. .. abc q,w,e,r,t
2 .. .. .. .. .. .. .. .. cde l,m,n,o

IIRC, the files normally have to be sorted when using join which makes it easy with the increasing ID column.