[Mingw-users] Possible malfunction with "join" command and unpaired lines.

[jonk <jo...@ol...>]

Hello=2E

I have a problem with =22join=22 command and unpaired lines=2E


I use the =22join=22 command with 2 input files=3A
join -t =22=7C=22 -a1 -a2 file1 file2 =3E output

where
=5Bfile1=5D
B=23CER2R-LLACUN1=7C136=2E57
B=23CER2R-LLACUN2=7C281=2E67
B=23CER2R-LLACUN3=7C105=2E11
B=23CER2R-LLACUN4=7C173=2E67
B=23CER2R-LLACUN5=7C275=2E42
B=23CER2R-LLACUN6=7C170=2E54
B=23CER2R-LUTXAN2=7C152=2E75
B=23CER2R-MFUSTA1=7C17=2E08
B=23CER2R-MORROT1=7C79=2E82
B=23CER2R-MORROT2=7C39=2E07
B=23CER2R-MORROT3=7C50=2E72
B=23CER2R-MORROT4=7C104=2E18
B=23CER2R-MORROT5=7C112=2E01
B=23CER2R-MORROT6=7C73=2E59

and
=5Bfile2=5D
B=23CER2R-LLACUN1=7C214
B=23CER2R-LLACUN2=7C660
B=23CER2R-LLACUN3=7C213
B=23CER2R-LLACUN4=7C352
B=23CER2R-LLACUN5=7C499
B=23CER2R-LLACUN6=7C341
B=23CER2R-LUTXAN1=7C122
B=23CER2R-LUTXAN2=7C296
B=23CER2R-LUTXAN3=7C110
B=23CER2R-MFUSTA1=7C36
B=23CER2R-MORROT1=7C105
B=23CER2R-MORROT2=7C63
B=23CER2R-MORROT3=7C80
B=23CER2R-MORROT4=7C131
B=23CER2R-MORROT5=7C190
B=23CER2R-MORROT6=7C88

Note that file2 has 2 unpaired lines=3A
B=23CER2R-LUTXAN1=7C122
B=23CER2R-LUTXAN3=7C110

My output file is therefore=3A
=5Boutput=5D
B=23CER2R-LLACUN1=7C136=2E57=7C214
B=23CER2R-LLACUN2=7C281=2E67=7C660
B=23CER2R-LLACUN3=7C105=2E11=7C213
B=23CER2R-LLACUN4=7C173=2E67=7C352
B=23CER2R-LLACUN5=7C275=2E42=7C499
B=23CER2R-LLACUN6=7C170=2E54=7C341
B=23CER2R-LUTXAN1=7C122
B=23CER2R-LUTXAN2=7C152=2E75=7C296
B=23CER2R-LUTXAN3=7C110
B=23CER2R-MFUSTA1=7C17=2E08=7C36
B=23CER2R-MORROT1=7C79=2E82=7C105
B=23CER2R-MORROT2=7C39=2E07=7C63
B=23CER2R-MORROT3=7C50=2E72=7C80
B=23CER2R-MORROT4=7C104=2E18=7C131
B=23CER2R-MORROT5=7C112=2E01=7C190
B=23CER2R-MORROT6=7C73=2E59=7C88

This way I know that there are unpaired lines=2C but I don=B4t know which=
 =

file they come from


But I would like =22join=22 to produce the next output=3A
=5Bdesirable=5Foutput=5D
B=23CER2R-LLACUN1=7C136=2E57=7C214
B=23CER2R-LLACUN2=7C281=2E67=7C660
B=23CER2R-LLACUN3=7C105=2E11=7C213
B=23CER2R-LLACUN4=7C173=2E67=7C352
B=23CER2R-LLACUN5=7C275=2E42=7C499
B=23CER2R-LLACUN6=7C170=2E54=7C341
B=23CER2R-LUTXAN1=7C =7C122
B=23CER2R-LUTXAN2=7C152=2E75=7C296
B=23CER2R-LUTXAN3=7C =7C110
B=23CER2R-MFUSTA1=7C17=2E08=7C36
B=23CER2R-MORROT1=7C79=2E82=7C105
B=23CER2R-MORROT2=7C39=2E07=7C63
B=23CER2R-MORROT3=7C50=2E72=7C80
B=23CER2R-MORROT4=7C104=2E18=7C131
B=23CER2R-MORROT5=7C112=2E01=7C190
B=23CER2R-MORROT6=7C73=2E59=7C88

Where the blanks tell me that file1 has unpaired lines=2E This gives me =

much more information=2E
How can I fix this=3F I have browsed source code (join=2Ec)=2C but I am n=
ot =

an expert programmer=2E

Thank you very much=2E