I have two files File AMUREX_2089975   :SBE Zinc Non-Option    118510  metals  USD -308410MUREX_2097300   :SBE Zinc Non-Option    118510  metals  USD 7751MUREX_2097474   :SBE Zinc Non-Option    118510  metals  USD -140062MUREX_2097928   :SBE Zinc Non-Option    118510  metals  USD 46504MUREX_2099168   :SBE Zinc Non-Option    118510  metals  USD 38906MUREX_2102690   :SBE Zinc Non-Option    118510  metals  USD -139992MUREX_2106241                   MUREX_2106570                   MUREX_2106577                   MUREX_2107869                   MUREX_748219    :SBE Zinc Non-Option    118510  metals  USD 7743MUREX_777665    :SBE Zinc Non-Option    118510  metals  USD 7750MUREX_778819    :SBE Zinc Non-Option    118510  metals  USD 7743File BMUREX_2089975   :SBE Zinc Non-Option    118510  metals  USD -296889MUREX_2097300   :SBE Zinc Non-Option    118510  metals  USD 7450MUREX_2097474                   MUREX_2097928   :SBE Zinc Non-Option    118510  metals  USD 44699MUREX_2099168                   MUREX_2102690   :SBE Zinc Non-Option    118510  metals  USD -134474MUREX_2106241   :SBE Zinc Non-Option    118510  metals  USD 7450MUREX_2106570   :SBE Zinc Non-Option    118510  metals  USD -14942MUREX_2106577   :SBE Zinc Non-Option    118510  metals  USD -14942MUREX_2107869   :SBE Zinc Non-Option    118510  metals  USD 7450MUREX_748219    :SBE Zinc Non-Option    118510  metals  USD 7444MUREX_777665    :SBE Zinc Non-Option    118510  metals  USD 7453MUREX_778819    :SBE Zinc Non-Option    118510  metals  USD 7444Code that I am using:join -t, -j 1 -a 1 -a 2 -o auto FileA FileBWhat I want is basically to compare column 6 from each file while full fill out column 1 to 5. Expected OutcomeMUREX_2089975   :SBE Zinc Non-Option    118510  metals  USD -308410 -296889MUREX_2097300   :SBE Zinc Non-Option    118510  metals  USD 7751    7450MUREX_2097474   :SBE Zinc Non-Option    118510  metals  USD -140062 MUREX_2097928   :SBE Zinc Non-Option    118510  metals  USD 46504   44699MUREX_2099168   :SBE Zinc Non-Option    118510  metals  USD 38906   MUREX_2102690   :SBE Zinc Non-Option    118510  metals  USD -139992 -134474MUREX_2106241   :SBE Zinc Non-Option    118510  metals  USD         7450MUREX_2106570   :SBE Zinc Non-Option    118510  metals  USD         -14942MUREX_2106577   :SBE Zinc Non-Option    118510  metals  USD         -14942MUREX_2107869   :SBE Zinc Non-Option    118510  metals  USD         7450MUREX_748219    :SBE Zinc Non-Option    118510  metals  USD 7743    7444MUREX_777665    :SBE Zinc Non-Option    118510  metals  USD 7750    7453MUREX_778819    :SBE Zinc Non-Option    118510  metals  USD 7743    7444Actual OutcomeMUREX_2089975   :SBE Zinc Non-Option    118510  metals  USD -308410 :SBE Zinc Non-Option    118510  metals  USD -296889MUREX_2097300   :SBE Zinc Non-Option    118510  metals  USD 7751    :SBE Zinc Non-Option    118510  metals  USD 7450MUREX_2097474   :SBE Zinc Non-Option    118510  metals  USD -140062                 MUREX_2097928   :SBE Zinc Non-Option    118510  metals  USD 46504   :SBE Zinc Non-Option    118510  metals  USD 44699MUREX_2099168   :SBE Zinc Non-Option    118510  metals  USD 38906                   MUREX_2102690   :SBE Zinc Non-Option    118510  metals  USD -139992 :SBE Zinc Non-Option    118510  metals  USD -134474MUREX_2106241                                                       :SBE Zinc Non-Option    118510  metals  USD 7450MUREX_2106570                                                       :SBE Zinc Non-Option    118510  metals  USD -14942MUREX_2106577                                                       :SBE Zinc Non-Option    118510  metals  USD -14942MUREX_2107869                                                       :SBE Zinc Non-Option    118510  metals  USD 7450MUREX_748219    :SBE Zinc Non-Option    118510  metals  USD 7743    :SBE Zinc Non-Option    118510  metals  USD 7444MUREX_777665    :SBE Zinc Non-Option    118510  metals  USD 7750    :SBE Zinc Non-Option    118510  metals  USD 7453MUREX_778819    :SBE Zinc Non-Option    118510  metals  USD 7743    :SBE Zinc Non-Option    118510  metals  USD 7444edit1: One example of how the the data actually looks like: MUREX_990422,:SBE Zinc Non-Option,118510,metals,USD,15501
Join two files each with two columns that have multiple columns are matched
text processing;join