Shell Programming and Scripting

Hi guys,

I'm rather new at using UNIX based systems, and when it comes to scripting etc I'm even newer.

I have two files which i need to compare.

file1: (some random ID's)

451245
451288
136588
784522


file2: (random ID's + e-mail assigned to ID)

123888 xc@xc.com
451245 a@a.com
122112 adsadas@asd.com
451288 b@b.com
136588 c@c.com
784522 d@d.com

My thoughts on this, was to have the script print $2 of file2 if there's a match on that particular ID from in the File1.

So it cant do a per line search i guess, it needs to look throughout the file and search for a match.
I would like it to store the output in a .txt file aswell - I know you can do that by > randomfile.txt right?

I hope you get what I'm talking about :-D


Best regards
Jesper

try

Code:

awk 'NR==FNR{a[$1,$2]=$3;next} a[$1,$2]{print $2}' file2 file1

Hi, thanks for answering. I'm getting this when trying to run it.

awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: bailing out near line 1

do you have solaris? if so; try:

Code:

nawk 'NR==FNR{a[$1,$2]=$3;next} a[$1,$2]{print $2}' file2 file1

Yeah im using solaris, and nawk did the trick. Not getting any errors now :-) I doesn't seem to print anything out tho, is this wrong?

nawk 'NR==FNR{a[$1,$2]=$3;next} a[$1,$2]{print $2}' file2 file1 > output.txt

you should see the result. something is wrong. try:

Code:

nawk 'NR==FNR {a[$1$2]++;next} a[$1$2] { print $2 }' file2 file1

you can find similar detailed sol'n at:
https://www.unix.com/shell-programming-scripting/147237-easily-search-file-get-line-little-problem-post302466738.html

Use grep with the -f option. Check your man page.

That shouldn't work since the first file has only one column.