Shell Programming and Scripting

cat file1:

Name: server1.data.com
data1 server1 running

Name: server3.data.com
data3 server3 running


cat file2:
server1  good
server2  bad
network not ok
server3 good


Output:
good running data1 server1 server1.data.com
good running data3 server3  server3.data.com

awk 'NR==FNR{if($1 ~ /Name/){d=$2;gsub(/\..*/,X,$2);c=$2;getline;A[c]=$NF  OFS $(NF-1) OFS $(NF-2) OFS d}} ($1 in A){print $2 OFS A[$1]}' file1 file2
OR
awk 'NR==FNR{if($1 ~ /Name/){d=$2;gsub(/\..*/,X,$2);c=$2;getline;A[c]=$NF  OFS $1 OFS $2 OFS d}} ($1 in A){print $2 OFS A[$1]}' file1 file2

good running data1 server1 server1.data.com
good running data3 server3 server3.data.com

Name: server1.data.com OTHER DATA IN IT(I WANT TO CAPTURE)
data1 OTHERs OTHERS  server1 running

cat file1
Name: server1.data.com Singh is King
data1 server1 running
Name: server3.data.com ravinder singh
data3 server3 running
 
cat file2
server1  good
server2  bad
network not ok
server3 good

awk 'NR==FNR{if($1 ~ /Name/){d=$2;gsub(/\..*/,X,$2);c=$2;$2=$1="";h=$0;getline;A[c]=$NF  OFS $(NF-1) OFS $(NF-2) OFS d OFS h}} ($1 in A){print $2 OFS A[$1]}' file1 file2

good running server1 data1 server1.data.com   Singh is King
good running server3 data3 server3.data.com   ravinder singh

NR==FNR                                                                       ##### This condition will be true when first file will be read #####
if($1 ~ /Name/                                                                 ##### Looking for line's whose first field has word Name #######
d=$2;gsub(/\..*/,X,$2)                                                     ##### Saving $2 in a variable named d, then removing everything from .(dot) to till end of field 2 #######
c=$2                                                                                 ###### Saving this new value of $2 in a variable named c #######
$2=$1="";h=$0                                                                ##### Making $2 and $1 to NULL and saving rest f line to a variable named h ########
getline                                                                              ##### Moving onto next line now ########
A[c]=$NF  OFS $(NF-1) OFS $(NF-2) OFS d OFS h   ##### Now creating a array named A whose index is c(which has data manipulated $2 in step-4) 
                                                                                        ##### OFS is Output Field separator and NF is number of fields and these values are taken as per request #####
($1 in A)                                                                         ##### Now this statement will be executed when File2 is read as we have ended condition of NR==FNR before it ######
{print $2 OFS A[$1]}                                                    ##### printing $2 of file2 and array A's value#######

Data1:
Name  data W3
us-west-2b running i-21690a303 192.216.3.20   None
Name  outlook  M7
us-west-2a stopped i-2103a9ee8 192.216.1.47   None
Name  wow Master Device
us-west-2c running i-21c95a6e9 192.216.7.80   None
Name  MySQL S2
us-west-2b running i-21295a637 192.216.3.41   None

Data2:
192.216.7.80 server1.com
192.216.3.20  server2.com

Output:
server1.com  192.216.7.80   i-21c95a6e9  us-west-2b   wow Master Device