I have the first file with 1099 columns
#rnaseq/SNPID hg19Location Gene TCGA-BH-A0C0-01A TCGA-A2-A3XY-01A TCGA-XX-A89A-01A TCGA-B6-A0I2-01A TCGA-LL-A6FP-01A TCGA-EW-
rnaseq - ?|100133144 7.8666 9.6884 22.3240 1.8760 2.0161 7.8383 5.3991 0.0857 4.5513 15.4363 15.0035 4.3578 0.6809 2.5364 12.4086 11.5839
the columns I want to compare starts with column 3
TCGA-BH-A0C0-01A TCGA-A2-A3XY-01A TCGA-XX-A89A-01A TCGA-B6-A0I2-01A TCGA-LL-A6FP-01A TCGA-EW-
the second file is 1119 columns
[1]#SNPID hg19Location Gene AlleleA AlleleB dbSNP nSample TCGA-AC-A3TN-01A-11D-A227-01 TCGA-V7-A7HQ-01A-11D-A33D-01 TCGA-BH-A18R-01A-
[2]SNP_A-1780270 chr7:78599583:- MAGI2|ENSG00000187391.13 C G rs987435 2236 1_0.002700 1_0.006000 1_0.000300
the columns I want to compare start with column 8
TCGA-AC-A3TN-01A-11D-A227-01 TCGA-V7-A7HQ-01A-11D-A33D-01 TCGA-BH-A18R-01A-
so that I want to match the columns names in first file to the second file so that the second file will have only the same column names as the first file
so basically I want the same column names in both files