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 protected]
[email protected]
[email protected]

file2:

[email protected]:addressotest
[email protected]:clubbingson
[email protected]:addresso2

output:

[email protected]:addresso2
[email protected]:addressotest

i've tried awk 'FNR==NR{a[$1]=$0; next}{print a[$1] $0}' file1 file2 but does not work — Johnny B
– Johnny B, Commented Feb 2, 2018 at 7:06
Post some sample data with expected output, please. We don't enjoy the quessing game. — James Brown
– James Brown, Commented Feb 2, 2018 at 7:07
You need to set the field separator for file2. Try awk -F: [your code here] file1 file2. — James Brown
– James Brown, Commented Feb 2, 2018 at 7:11

RavinderSingh13 · Accepted Answer · 2018-02-02 07:14:40Z

1

Following awk may help you in same.

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

answered Feb 2, 2018 at 7:14

RavinderSingh13

135k14 gold badges61 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

RavinderSingh13 Over a year ago

@JohnnyB, it worked for me, what error are you getting?

Johnny B Over a year ago

Im not getting any errors, the command responds as if no matches were found

RavinderSingh13 Over a year ago

@JohnnyB, did you run the exact command? It is working fine for me.

Johnny B Over a year ago

I tried it with the examples I provided, it works, but when I try it with my actual files, it does not work. (the files I have are big files)

James Brown Over a year ago

Then the files probably differ from samples somehow. How big are the files?

|

karakfa · Accepted Answer · 2018-02-02 15:11:13Z

1

join with presorting input files

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

[email protected]:addressotest
[email protected]:addresso2

answered Feb 2, 2018 at 15:11

karakfa

67.8k8 gold badges45 silver badges59 bronze badges

Comments

Allan · Accepted Answer · 2018-02-02 07:51:01Z

0

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 protected]
[email protected]
[email protected]
::::::::::::::
file2
::::::::::::::
[email protected]:addressotest
[email protected]:clubbingson
[email protected]:addresso2

$join -t':' file1 file2
[email protected]:addressotest
[email protected]: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

edited Feb 2, 2018 at 7:51

answered Feb 2, 2018 at 7:36

Allan

12.5k3 gold badges33 silver badges56 bronze badges

4 Comments

Johnny B Over a year ago

I've tried this, but I get join: file2.txt: 4 is not sorted: [email protected]:addressotest join file1.txt:2: is not sorted: [email protected]

Allan Over a year ago

what is your sorting criteria?

Allan Over a year ago

@JohnnyB I have edited my answer please have a look! ;-)

karakfa Over a year ago

you have to sort input files!

Collectives™ on Stack Overflow

Awk: How do I output data from two files

3 Answers 3

6 Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related