what were your attempts? I got nothing at first because i didn't specifiy the comma delimiter with -t (default is tab)... what i posted above worked and that was the actual output... worth a quick glance of the man page in case the params are slightly different for your system? | [reply] |
Well.... If I type a few lines of each file out manually, the join works. Otherwise the join returns nothing. In vi I've used the set list to check for special character but there isn't any.
Any idea what could be causing the problem?
| [reply] |
What is the exact join command that "returns nothing"? What do the the two files look like? As stated before, it's like a delimiter issue, or (the -1 and -2 options) you're not telling it which fields to join on (it assumes the first field of each file by default).
| [reply] |
This sounds like you might have carriage returns or extra whitespaces at line ends in (at least one of) the original files. That's just a guess of course.
Update: you have to sort the lines (with the fields you want to join as keys) if you want to join the files. You didn't forget that, did you?
| [reply] |