an urgent problrm

Question

[Alex]

Hello everyone ,I have two files and file1 like this :

CUST_997_PI416562355    7.194102229     7.631830326     8.303762671     8.004198217

CUST_10_PI416562355     8.979145891     7.274049999     9.279528846     7.829499436

CUST_10_PI416679341     11.516932698    11.81085237     11.645307687    11.847884797

file2 like this :

CUST_10_PI416562355     10.914125192    8.682432105     8.028920172     8.887303764

CUST_10_PI416679341     11.654895842    11.748698054    11.611811664    11.694144421

CUST_1000_PI416568369   8.851053415     8.122645753     7.728531364     8.448358106

I want to obtain file3 like this :

CUST_10_PI416562355     8.979145891     7.274049999     9.279528846     7.829499436

CUST_10_PI416562355     10.914125192    8.682432105     8.028920172     8.887303764

I am poor in awk and need the answers,can everyone help me? thanks

Alex

[WouterDeCoster]

Please chose a more descriptive title for your thread. You also didn't describe how file1 and file2 should be combined to form file3. Showing an example is good, but not sufficient.
In addition, your problem is not more urgent than other problems for us and will not get a priority treatment just because you say so.

[Alex]

I'm so sorry for for the problem is not clearly,yeah,I want to obtain the file 1 and file 2 commom things whose first Column names is the same and others Column different. finally combine the file1 and file2 commom things to another file Alex

[WouterDeCoster]

So only "CUST_ identifiers" present in both files should be kept, and then all rows for those identifiers?

[Ram]

Hello Alex!

We believe that this post does not fit the main topic of this site.

Not bioinformatics. Also, title and content need more etiquette.

For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.

If you disagree please tell us why in a reply below, we'll be happy to talk about it.

Cheers!

Answer 1

[Pierre Lindenbaum]

join  -t $'\t' -1 1 -2 1 <(sort -t $'\t' -k1,1 file1) <(sort -t $'\t' -k1,1 file2)

for a start

[Alex]

Dear Lindenbaum , while it's seems dosen't work well for my file