linux - Column matching -

deleted

deleted deleted

deleted

deleted deleted deleted

first, pre-processing. remove headers (the first 2 lines in both files). then, make tab field separator. sort on second field , b on first field. lets leads files "a" , "b". then, join command can used.

$ cat eva high school f bill    post graduate   m eddie   post graduate   m john    unviersity  m mary    unviersity  f peter   unviersity  m $ cat b high school b post graduate   c unviersity  $ join -12 -21 -t$'\t' b  high school eva f   b post graduate   bill    m   c post graduate   eddie   m   c unviersity  john    m   unviersity  mary    f   unviersity  peter   m   

you can run final output through awk required format.