awk: if pattern is matched append some data

Question

I have a data set created by a tool with file name test.deg. The file contents is as follows:

1         I0.XPDIN1      1.581e-01  1.507e-01  3.662e-04  3.891e-02   
2         I0.XPXA1    1.577e-01  1.502e-01  3.653e-04  3.859e-02   
3         I0.XPXA2    1.538e-01  1.444e-01  3.552e-04  3.471e-02    

I have a second file ,test.spf, containing the following information:

XPDIN1 XPDIN1#d XPDIN1#g XPDIN1#s VPP
XPXA1 XPXA1#d XPXA1#g XPXA1#s VPP
XPXA2 XPXA2#d XPXA2#g XPXA2#s VPP

I am trying to write an awk script that matches the Instance name from test.deg to the instance name in test.spf. When the script sees a match I would like the 5th column's contents appended to that matched instance name's line end. Example output for I0.XPDIN1 in test.deg would be XPDIN1 XPDIN1#d XPDIN1#g XPDIN1#s VPP 3.662e-04

The script needs to match the instance name from test.deg after the prefix I0. to the first instance name call in test.spf then add the 5th columns data.

Thanks, Bad Awk

Answer 1

GNU Awk

$ awk 'FNR==NR{a[$2]=$5; next} ("I0."$1 in a){$6=a["I0."$1]}1' test.deg test.spf
XPDIN1 XPDIN1#d XPDIN1#g XPDIN1#s VPP 3.662e-04
XPXA1 XPXA1#d XPXA1#g XPXA1#s VPP 3.653e-04
XPXA2 XPXA2#d XPXA2#g XPXA2#s VPP 3.552e-04