plz help in merging files
 

Hi I am new to scripting!
Please help me achieve the following.
i have 2 files, inventory and exception

contents of inventory
tokw01 10.15.12.1
lonw01 20.15.13.1
ausw01 30.15.16.1

contents of exception
10.15.12.1 CPU=90%
30.15.16.1 MEM=80%

file alarmed should&only have
tokw01 10.15.12.1 CPU=90%
ausw01 30.15.16.1 MEM=80%

thanks in advance!
-Prem

What have you tried so far? You can read the file inventory line by line, extract the second field and look for it in the file exception using grep.

Check out the join command.

join worked :) thanks a ton Matthew!