I'm trying to join two
csv files, sorted, and with tab delimiter.
I'm new to the
join command, so I'm not too sure about how to use it, but it seems to be replacing every tab in the files with spaces (messing up the alignment).
The command I'm using is:
join -1 5 -2 2 -t $'\t' -o $order --header file1.csv file2.csv | column -t > result.csv
In the first file, the data is sorted according to the 5th column, and the 2nd column in the second file.
$order is a simple string containing the different columns '1.1 1.2 1.3' etc. (28 of them).
The delimiter I'm using comes from SE.
Do you know where this comes from?