UNIX for Dummies Questions & Answers

Hi All,

I have a problem in appending the files

File 1
0.0000001 0.500000039894
0.0000002 0.500000079788
0.0000003 0.500000119683
0.0000004 0.500000159577
0.0000005 0.500000199471
0.0000006 0.500000239365
0.0000007 0.500000279260
0.0000008 0.500000319154
0.0000009 0.500000359048
0.0000010 0.500000398942

File 2
0.0000001 -5.199337582193
0.0000002 -5.068957749718
0.0000003 -4.991217139908
0.0000004 -4.935367444719
0.0000005 -4.891638475699

The output should be something like

0.0000001 0.500000039894 -5.199337582193
0.0000002 0.500000079788 -5.068957749718
0.0000003 0.500000119683 -4.991217139908
0.0000004 0.500000159577 -4.935367444719
0.0000005 0.500000199471 -4.891638475699
0.0000006 0.500000239365
0.0000007 0.500000279260
0.0000008 0.500000319154
0.0000009 0.500000359048
0.0000010 0.500000398942

I searched the forum and was able to figure that it can be done using the following awk command.

nawk -f app.awk File2 File1

Code for app.awk:

BEGIN { FS=OFS=" " }
FNR == NR { arr[$1]=$2; next }
{ $NF=($1 in arr) ? arr[$1] : " "; print }

But still the output is not as expected. I am getting the output as

0.0000001 -5.199337582193
0.0000002 -5.068957749718
0.0000003 -4.991217139908
0.0000004 -4.935367444719
0.0000005 -4.891638475699
0.0000006
0.0000007
0.0000008
0.0000009
0.0000010

Please help me...

Thanks
Shash

Code:

FNR == NR { arr[$1]=$2; next }
{ $(NF+1)=($1 in arr) ? arr[$1] : " "; print }

Thanks a lot vgersh99!. It worked. I think when I searched the forum it was your answer which I took at the first time. You are a genius.

Thanks
Shash