Combine multiple files

zhshqzyc
zhshqzyc used Ask the Experts™
on
Hi, I have many file s to be combined. Ex,
File 1
ID  h1 h2 h3
a   1  5  7
b   3  3  5
c   0  4  8

Open in new window

File 2
ID h4 h5 h6
a  2  4  9
b  3  6  1
f  4  1  5

Open in new window

Expected files
ID  h1  h2  h3  h4 h5  h6
a   1   5   7   2   4   9 
b   3   3   5   3   6   1
c   0   4   8 
f               4   1   5

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
There is a similar solution at here
How can I apply the priciple?

Thanks for help.
AndyAinscowFreelance programmer / Consultant

Commented:
What is wrong with the comment you accepted as solution in your other post?  If it doesn't work then request that it be reopened.

Author

Commented:
I am sorry, I can't follow you. I don't understand your comment. It is a different question.
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

IT Consultant
Top Expert 2010
Commented:
This question appears to be 100%, absolutely identical to http:Q_26967426.html.  You have accpeted a solution in that question, http:Q_26967426.html#a35440719, which appears to be a good answer - if that answer does not work for you should use the "Requestion Attention" link on that question and ask that it be re-opened.

Author

Commented:
Okay. Thanks for advice. A little modification. If ID is in the second column, how to modify the code?
h1 ID  h2  h3
1   a   5   7
3   b   3   5
0   c   4   8 

Open in new window

AndyAinscowFreelance programmer / Consultant
Commented:
It helps you a lot more to think about what the code supplied does.  A change like that should be pretty trivial to implement.

Author

Commented:
Thanks you. I will try it by myself.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial