CODEWITHSUNDEEP
unixmergeedittext-processing
user1693559
user1693559

Reputation: 21

Merging columns in several text files

I have several text files with this format

FILE1:

ID1 field1 field2
ID2 field1 field2
ID3 field1 field2
ID4 
ID5 field1 field2
ID6 field1 field2

FILE2:

    ID1 field3 field4
    ID2 field3 field4
    ID3 
    ID4 field3 field4
    ID5 field3 field4
    ID6 field3 field4

As you can see the fields may be missing in some of the rows. What I want to do is merge all the text files together by the ID column under unix language.

My output should be like this: OUTPUT FILE:

ID1 field1 field2 field3 field4 field5 ... etc
ID2 field1 field2 field3 field4 field5 ... etc
ID3 field1 field2 inserted string field5 ... etc
ID4 inserted string field3 field4 field5 ... etc
ID5 field1 field2 field3 field4 field5 ... etc
ID6 field1 field2 field3 field4 field5 ... etc

I have tried different commands but I usually ended up with a different number of rows. I appreciate any help. Thanks

Upvotes: 0

Views: 56

Answers (1)

SenthilPrabhu
SenthilPrabhu

Reputation: 659

join file1 file12 -t $'inserted '

Upvotes: 1

Related Questions