Help with scripting

Northerner · #1 (**permalink**) 2 Days Ago

I have 2 files with a common parm - Jobname

File 1
0507 1202 JOBA
0507 1302 JOBB
0507 1452 JOBC
0507 1552 JOBA
0507 1553 JOBA

File2

JOBA abcdefg server4
JOBB defghij server22
JOBC vwxyz12 server55

I would like to take each line from File1 and match the jobname with the jobname in File 2 and produce File 3 as

0507 1202 JOBA abcdefg server4
0507 1302 JOBB defghij server22
0507 1452 JOBC vwxyz12 server55
0507 1552 JOBA abcdefg server4
0507 1553 JOBA abcdefg server4

Could anyone help please, I'm new to scripting.

aju_kup · #2 (**permalink**) 2 Days Ago

Code:

nawk 'NR == FNR{rec[$1] = $2" " $3; next}

{ print $0 " " rec[$3]}

' 64491_merge1.d 64491_merge.d

output

Code:

0507 1202 JOBA abcdefg server4
0507 1302 JOBB defghij server22
0507 1452 JOBC vwxyz12 server55
0507 1552 JOBA abcdefg server4
0507 1553 JOBA abcdefg server4

Northerner · #3 (**permalink**) 2 Days Ago

Brilliant Thanks very much indeed!

radoulov · #4 (**permalink**) 2 Days Ago

Another one:
(use nawk or /usr/xpg4/bin/awk on Solaris)

Code:

awk 'NR==FNR{x[$1]=$0;next}$NF=x[$NF]' file2 file1