Quote:
Originally Posted by pan64
where is this script from? It looks like you mixed $1 and $2:
Code:
awk 'NR==FNR{a[$2]=$1;next}; ($2 in a) {print $0","a[$2]}' file2-new file1-new
|
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.