file1:
22 epc.XYZ000.ABC454.3gppnetwork.org
1506 epc.XYZ000.ABC460.3gppnetwork.org
2 epc.XYZ001.ABC202.3gppnetwork.org
2 epc.XYZ001.ABC206.3gppnetwork.org
8 epc.XYZ001.ABC214.3gppnetwork.org
7 epc.XYZ001.ABC222.3gppnetwork.org
1 epc.XYZ001.ABC262.3gppnetwork.org
1 epc.XYZ001.ABC278.3gppnetwork.org
15 epc.XYZ001.ABC427.3gppnetwork.org
6 epc.XYZ001.ABC455.3gppnetwork.org


file 2:
India epc.XYZ000.ABC454.3gppnetwork.org
Germany epc.XYZ001.ABC206.3gppnetwork.org
Russia epc.XYZ001.ABC214.3gppnetwork.org
US epc.XYZ001.ABC222.3gppnetwork.org
China epc.XYZ000.ABC460.3gppnetwork.org
UAE epc.XYZ001.ABC278.3gppnetwork.org
UK epc.XYZ001.ABC262.3gppnetwork.org
Singapore epc.XYZ001.ABC427.3gppnetwork.org
Japan epc.XYZ001.ABC455.3gppnetwork.org
France epc.XYZ001.ABC202.3gppnetwork.org

Desired Output:

22 epc.XYZ000.ABC454.3gppnetwork.org India
1506 epc.XYZ000.ABC460.3gppnetwork.org China
2 epc.XYZ001.ABC202.3gppnetwork.org France
2 epc.XYZ001.ABC206.3gppnetwork.org Germany
8 epc.XYZ001.ABC214.3gppnetwork.org Russia
7 epc.XYZ001.ABC222.3gppnetwork.org US
1 epc.XYZ001.ABC262.3gppnetwork.org UK
1 epc.XYZ001.ABC278.3gppnetwork.org UAE
15 epc.XYZ001.ABC427.3gppnetwork.org Singapore
6 epc.XYZ001.ABC455.3gppnetwork.org Japan

When i tried with below command, its not generating any o/p.

awk 'FNR==NR{a[$1]=$2;next} ($2 in a) {print $1,$2,a[$1]}' file2 file1.

Can any one guide me to fix the error ?

Diagnostics 101 - insert some print statements; everything you use, print. Very illuminating usually.

Sorry, not clear

Now i made files as (,) separated and tried this one. But it doesn't merge with 2nd file.

#awk -F"," 'NR==FNR{a[$1]=$2;next}; ($2 in a); {print $0","a[$1]}' file2-new file1-new | tail -3

170,epc.XYZ260.ABC310.3gppnetwork.org,
8,epc.XYZ610.ABC302.3gppnetwork.org,
1,epc.XYZ720.ABC302.3gppnetwork.org,

Any suggestions ?

Note: File1 is bigger than file2

where is this script from? It looks like you mixed $1 and $2:

1 members found this post helpful.

Hi,

Its working perfectly. Can you please explain my mistake, also clarify your script too please ?

And one more thing.. I have many lines in file1, this script compares & merge only for the entry found in file2. It skips other lines in file1, which is not in the file2. Please help me to correct that as well.

eg: I want like below one.

22 epc.XYZ000.ABC454.3gppnetwork.org India
1506 epc.XYZ000.ABC460.3gppnetwork.org China
2 epc.XYZ001.ABC202.3gppnetwork.org France
2 epc.XYZ001.ABC206.3gppnetwork.org Germany
8 epc.XYZ001.ABC214.3gppnetwork.org Russia
7 epc.XYZ001.ABC222.3gppnetwork.org US
1 epc.XYZ001.ABC262.3gppnetwork.org UK
1 epc.XYZ001.ABC278.3gppnetwork.org UAE
15 epc.XYZ001.ABC427.3gppnetwork.org Singapore
6 epc.XYZ001.ABC455.3gppnetwork.org Japan
273 epc.XYZ005.ABC525.3gppnetwork.org N/A
24 epc.XYZ006.ABC454.3gppnetwork.org N/A
5 epc.XYZ006.ABC456.3gppnetwork.org N/A
4 epc.XYZ008.ABC204.3gppnetwork.org N/A
203 epc.XYZ008.ABC450.3gppnetwork.org N/A
3 epc.XYZ008.ABC456.3gppnetwork.org N/A
14 epc.XYZ010.ABC222.3gppnetwork.org N/A


thanks for your support.

I made it to work like this....

awk 'NR==FNR{a[$2]=$1;next}; {if($2 in a) print $0,a[$2]; else print $0,"N/A"}' file2 file1

But Please explain me, my earlier mistake

Or, using a ternary operator ("value if"):
The common key is $2 in both files.
So in file2 you index the array by $2 and store the $1 as a value.

1 members found this post helpful.

You need to understand how awk works, what do $0, $1 and $2 mean. Next, you will need to understand arrays, what will a[$2]=$1 do.
That's all (almost).

Yep, I'm confusing with that only. Can you please elaborate how it works & differs ?

you can find a huge amount of tutorials/examples/videos explaining awk.
https://www.tutorialspoint.com/awk/a...c_examples.htm
https://www.tutorialspoint.com/awk/awk_arrays.htm
http://spoken-tutorial.org/watch/Lin...f+awk/English/