Hello All,
I am trying to join two files, each with differing delimiters. file1 has
doe, john 10.00 60.00 4.00 5.00
...while file2 has the following content:
doe, johnz 10.00::60.00:4.00:5.00
Currently, I have join -1 1 -2 1 file1 file2 > file3 and the output only shows two of many lines and repeats some content on each line. Any idea how to ensure both files are joined and all lines are on the output?
$ join -1 1 -2 1 file1 file2
doe, john 10.00 60.00 4.00 5.00 johnz 10.00::60.00:4.00:5.00
doe, john 10.00 60.00 4.00 5.00 janet 10.00:60.00::4.00:5.00
doe, jane 10.00 60.00 4.00 5.00 johnz 10.00::60.00:4.00:5.00
doe, jane 10.00 60.00 4.00 5.00 janet 10.00:60.00::4.00:5.00
What is it you don't like about the result?
hanson44:
$ join -1 1 -2 1 file1 file2
doe, john 10.00 60.00 4.00 5.00 johnz 10.00::60.00:4.00:5.00
doe, john 10.00 60.00 4.00 5.00 janet 10.00:60.00::4.00:5.00
doe, jane 10.00 60.00 4.00 5.00 johnz 10.00::60.00:4.00:5.00
doe, jane 10.00 60.00 4.00 5.00 janet 10.00:60.00::4.00:5.00
What is it you don't like about the result?
The same code seems to be working fine now, not sure why the system delivered bad output several times earlier. Thanx for the prompt response.