join command

[Ken Senior]

Consider the following two files named say temp1.txt and temp2.txt

5.142600000000e+04, 85128,255.475409,38.803055,1.911757
 5.142600000000e+04, 85129,345.587870,-7.951330,.106654
 5.142600000000e+04, 85130,72.370920,-7.269845,-.064000
 5.142600000000e+04, 85131,167.730529,8.722500,.040038
 5.142600000000e+04, 85132,201.760672,21.561490,.426132
 5.142600000000e+04, 85402,138.647344,-34.729003,.038183
 5.142600000000e+04, 85403,301.480701,-34.573702,.048781
 5.142600000000e+04, 85404,358.716108,51.453742,.163113
 5.142600000000e+04, 85405,50.608143,26.209139,-.013853
 5.142600000000e+04, 85406,281.506391,-.215158,2.922667
 5.142600000000e+04, 85407,282.933776,38.920450,.059168
 5.142600000000e+04, 85409,115.892483,39.608602,.087642
 5.142600000000e+04, 85410,212.887034,64.687942,.176552
 5.142600000000e+04, 85411,174.778707,-41.272650,.046897
 5.142600000000e+04, 85412,28.224037,-25.746347,1.416440
 5.142600000000e+04, 86102,344.366724,27.763740,.197319



 5.142300000000e+04, 85128,255.475409,38.803055,1.911757
 5.156600000000e+04, 85129,345.587870,-7.951330,.106654
 5.198700000000e+04, 85130,72.370920,-7.269845,-.064000
 5.122600000000e+04, 85131,167.730529,8.722500,.040038
 5.412600000000e+04, 85132,201.760672,21.561490,.426132
 5.422600000000e+04, 85402,138.647344,-34.729003,.038183
 5.132600000000e+04, 85403,301.480701,-34.573702,.048781
 5.1122600000000e+04, 85404,358.716108,51.453742,.163113
 5.1123600000000e+04, 85405,50.608143,26.209139,-.013853
 5.132600000000e+04, 85406,281.506391,-.215158,2.922667
 5.162600000000e+04, 85407,282.933776,38.920450,.059168
 5.172600000000e+04, 85409,115.892483,39.608602,.087642
 5.182600000000e+04, 85410,212.887034,64.687942,.176552
 5.192600000000e+04, 85411,174.778707,-41.272650,.046897
 5.102600000000e+04, 85412,28.224037,-25.746347,1.416440
 5.122600000000e+04, 86102,344.366724,27.763740,.197319

I am trying to consider the space as the delimiter and join on
everything after the first comma.  The following two command should
produce identical results since " " is the default delimiter, but both
produce different results and neither is correct:

join -1 2 -2 2 temp1.txt temp2.txt
join -t " " -1 2 -2 2 temp1.txt temp2.txt

Ken Senior