Hi debian people, I have two files with the same number of rows but different columns. I want to create one file out of them and am looking for a simple shell command or shell script to accomplish that. File 1 has N number of rows and columns X,Y,Z and File 2 has N number of rows and P,Q,R as columns. The resulting file should have N number of rows and X,Y,Z,P,Q,R as columns. 1) Is there a simple command in Bash to accomplish this? 2) What would a script to do this look like? Uses Gawk? 3) If N=10000000 and the two files have 45 columns with mixed integer and character values, what would be the most efficient approach (fastest) and why? Thanks in advanced |