Awk: How do I output data from two files

Question

So yeah im trying to match file1 that contains email to file2 that cointains email colons address, how do i go on bout doing that?

tried awk 'FNR==NR{a[$1]=$0; next}{print a[$1] $0}' but idk what im doing wrong

file1:

email@email.email
email@test.test
test@email.email

file2:

email@email.email:addressotest
email@test.club:clubbingson
test@email.email:addresso2

output:

test@email.email:addresso2
email@email.email:addressotest

Answer 1

join with presorting input files

$ join -t: <(sort file1) <(sort file2)

email@email.email:addressotest
test@email.email:addresso2

Answer 2

Hey why going for a awk solution when you can simply use the following join command:

join -t':' file 1 file2

where join as its names indicate is just a file joining command and you chose the field separator and usually the input columns and output to display (here not necessary)

Tested:

$more file{1,2}
::::::::::::::
file1
::::::::::::::
email@email.email
email@test.test
test@email.email
::::::::::::::
file2
::::::::::::::
email@email.email:addressotest
email@test.club:clubbingson
test@email.email:addresso2

$join -t':' file1 file2
email@email.email:addressotest
test@email.email:addresso2

If you need to sort the output as well, change the command into:

join -t':' file 1 file2 | sort -t":" -k1 

or

join -t':' file 1 file2 | sort -t":" -k2

depending on which column you want to sort upon (eventually add the -r option to sort in reverse order.

join -t':' file 1 file2 | sort -t":" -k1 -r

or

join -t':' file 1 file2 | sort -t":" -k2 -r

Answer 3

Following awk may help you in same.

awk 'FNR==NR{a[$0];next} ($1 in a)' FILE_1 FS=":" FILE_2