Add new column from another file

freeroute · 08-02-2017, 06:12 PM

Hi,

I have 2 files.

file1 contains by lines: hash:salt:id
file2 contains by lines: username:hash:salt

I would like to add a new coloumn (id) form file1 to file2.

The new file should contains: username:hash:salt:id

Note: file1 contains less rows than file2
I tried

Code:

paste -d':' file1 file2

, but this solution not good for me.

Thank you

syg00 · 08-02-2017, 06:26 PM

Use join, not paste.

freeroute · 08-02-2017, 06:37 PM

Quote:

Originally Posted by syg00

Use join, not paste.

Tried, but this command does not work:

Quote:

join <(cat file1.txt | sort ) <(cat file2.txt | sort ) >final_file3.txt

I guess because of file1 contains less lines(users).

syg00 · 08-02-2017, 06:54 PM

Guess again.
You need to read the manpage - all of it, carefully. Join will join appropriate lines, and ignore unmatched.

scasey · 08-02-2017, 06:56 PM

from man join

Quote:

join [OPTION]... FILE1 FILE2

Please review the man document re: OPTIONs to see which apply to your case.

Edit: I shouldn't take so long to compose, I guess...what syg00 said, too.

kakistocrat · 08-02-2017, 09:47 PM

You probably also need to feed join with properly sorted data and sort on the field to be joined:

Code:

join ... <(sort -t: -k1,1 file1) <(sort -t: -k2,2 file2)