Shell Programming and Scripting

joining two files:

File1:
-----
1|M
2|M
3|F

File2:
-----
1|abc|def
3|xyz|pqr

join -t '|' 1.txt 2.txt gives(Itried many other ways)

1|M|abc|def
3|F|xyz|pqr

but I need the result like following

1|M|abc|def
2|M|||
3|F|xyz|pqr


any help is appreciated...Thanks

Ahmad,

it gives only the following

1|abc|def
3|xyz|pqr

Thanks for your reoply though...

Ahmad,

That works great, thank you so much, one last questionif you don't mind

now I have,

File 1:
-----
1|M|abc|def
2|M|
3|F|xyz|pqr

File2:
-----
1|MD|
1|MBBS|
2|NR
2|FR|
3|DN|

result should be

1|M|abc|def|MD|MBBS|
2|M|||NR|FR|
3|F|xyz|pqr|DN||

thanks for your help...

Ahmad,

sorry to bother you,...your code works great, but i have little tricky need here...please look inot this if you have few mins

file1:
----

1|abc|def|ghi|
2|aaa|bbb|ccc|

file2:
-----
1|P|1111111111|
1|P|2222222222|
1|F|3333333333|
2|P|7777777777|
1|P|8888888888|

after join I should get

1|abc|def|ghi|1111111111|3333333333|
2|aaa|bbb|ccc|7777777777||

basically from second file I took the first record as phone(P) and 3 record as FAX(F) for 1 and just phone for 2 as there is no fax for 2 in file 2...

hope I am clear...thanks again