Shell Programming and Scripting

something along these lines: nawk -f ken.awk OFS='\t' file1.txt file2.txt, where ken.awk is:

Code:

FNR==NR {
   if (NF==1) {
    if (/^[0-9.]+$/)
       ip=$1
    if (/[a-zA-Z.]$/)
       name[ip]=$1
   }
   next
}
NF {
  ip=substr($2,index($2,".")+1)
  gsub("[.][^0-9]+$","",ip)
  print ip, name[ip], $1, $3
}

Kenshinhimura:

You have been reminded to use code tags on so many occasions you are on the verge of being automatically tempbanned for having so many warnings. This would have already happened, if the unix.com forum software hadn't reminded me you were close to the limit. Please use code tags!

If you are confused on the process, view this video we have prepared for your convenience.

If you can't play the video, or the button doesn't work in your browser or phone, then type them yourself -- like this. [code]stuff[/code]

good script...thanks all..sorry mods..
but the script is not dynamic..what if..tehre is no ip.1.1.1.1.blah..

only 1.1.1.1 it will omit..

but thanks

---------- Post updated at 04:13 PM ---------- Previous update was at 04:12 PM ----------

Team,
you may use the commands given by our genuises here, to all admins that has large inventory of servers..awk is very powerful

What does "not dynamic" mean exactly?
Could you post a representative sample to capture all the cases and the desired output, please?!

---------- Post updated at 05:22 PM ---------- Previous update was at 05:17 PM ----------

I think this is what you're after:

Code:

FNR==NR {
   if (NF==1) {
    if (/^[0-9.]+$/)
       ip=$1
    if (/[a-zA-Z.]$/)
       name[ip]=$1
    }
   next
}
NF {
  ip=substr($2,index($2,".")+1)
  gsub("[.][^0-9]+$","",ip)
  print ip, name[ip], $1, $3
  delete name[ip]
}
END {
  for (i in name)
     print i, name[i]
}