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

[Earnie B. <ea...@us...>]

BoydE@QWEST-WKCH1I7I3 ~
$ join
sh: join: command not found

So did you post to the wrong list?

Earnie.

jonk wrote:
> Hello.
>=20
> I have a problem with "join" command and unpaired lines.
>=20
>=20
> I use the "join" command with 2 input files:
> join -t "|" -a1 -a2 file1 file2 > output
>=20
> where
> [file1]
> B#CER2R-LLACUN1|136.57
> B#CER2R-LLACUN2|281.67
> B#CER2R-LLACUN3|105.11
> B#CER2R-LLACUN4|173.67
> B#CER2R-LLACUN5|275.42
> B#CER2R-LLACUN6|170.54
> B#CER2R-LUTXAN2|152.75
> B#CER2R-MFUSTA1|17.08
> B#CER2R-MORROT1|79.82
> B#CER2R-MORROT2|39.07
> B#CER2R-MORROT3|50.72
> B#CER2R-MORROT4|104.18
> B#CER2R-MORROT5|112.01
> B#CER2R-MORROT6|73.59
>=20
> and
> [file2]
> B#CER2R-LLACUN1|214
> B#CER2R-LLACUN2|660
> B#CER2R-LLACUN3|213
> B#CER2R-LLACUN4|352
> B#CER2R-LLACUN5|499
> B#CER2R-LLACUN6|341
> B#CER2R-LUTXAN1|122
> B#CER2R-LUTXAN2|296
> B#CER2R-LUTXAN3|110
> B#CER2R-MFUSTA1|36
> B#CER2R-MORROT1|105
> B#CER2R-MORROT2|63
> B#CER2R-MORROT3|80
> B#CER2R-MORROT4|131
> B#CER2R-MORROT5|190
> B#CER2R-MORROT6|88
>=20
> Note that file2 has 2 unpaired lines:
> B#CER2R-LUTXAN1|122
> B#CER2R-LUTXAN3|110
>=20
> My output file is therefore:
> [output]
> B#CER2R-LLACUN1|136.57|214
> B#CER2R-LLACUN2|281.67|660
> B#CER2R-LLACUN3|105.11|213
> B#CER2R-LLACUN4|173.67|352
> B#CER2R-LLACUN5|275.42|499
> B#CER2R-LLACUN6|170.54|341
> B#CER2R-LUTXAN1|122
> B#CER2R-LUTXAN2|152.75|296
> B#CER2R-LUTXAN3|110
> B#CER2R-MFUSTA1|17.08|36
> B#CER2R-MORROT1|79.82|105
> B#CER2R-MORROT2|39.07|63
> B#CER2R-MORROT3|50.72|80
> B#CER2R-MORROT4|104.18|131
> B#CER2R-MORROT5|112.01|190
> B#CER2R-MORROT6|73.59|88
>=20
> This way I know that there are unpaired lines, but I don=B4t know which=
=20
> file they come from
>=20
>=20
> But I would like "join" to produce the next output:
> [desirable_output]
> B#CER2R-LLACUN1|136.57|214
> B#CER2R-LLACUN2|281.67|660
> B#CER2R-LLACUN3|105.11|213
> B#CER2R-LLACUN4|173.67|352
> B#CER2R-LLACUN5|275.42|499
> B#CER2R-LLACUN6|170.54|341
> B#CER2R-LUTXAN1| |122
> B#CER2R-LUTXAN2|152.75|296
> B#CER2R-LUTXAN3| |110
> B#CER2R-MFUSTA1|17.08|36
> B#CER2R-MORROT1|79.82|105
> B#CER2R-MORROT2|39.07|63
> B#CER2R-MORROT3|50.72|80
> B#CER2R-MORROT4|104.18|131
> B#CER2R-MORROT5|112.01|190
> B#CER2R-MORROT6|73.59|88
>=20
> Where the blanks tell me that file1 has unpaired lines. This gives me=20
> much more information.
> How can I fix this? I have browsed source code (join.c), but I am not=20
> an expert programmer.
>=20
> Thank you very much.
>=20
>=20
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> MinGW-users mailing list
> Min...@li...
>=20
> You may change your MinGW Account Options or unsubscribe at:
> https://lists.sourceforge.net/lists/listinfo/mingw-users
>=20

--=20
http://www.mingw.org
Powered by SourceForge <http://sourceforge.net/projects/mingw>