Shell Programming and Scripting

Input File:
=====================================
"Server1" srvgrp="group1" srvid=10
CLOPT="-A -r -e /path/logfile -o /path/stdout"
VAR1=0666 VAR2=N VAR3=0666 MIN=3 VAR4=4 VAR5=N
VAR6=FASTPATH
VAR7=5 VAR8=86400 VAR9=Y
VAR10=0 VAR11=1 VAR12=0
VAR13="0"
"Server1" srvgrp="group1" srvid=20
CLOPT="-A -r -e /path/logfile -o /path/stdout"
ENVVAR="/path/var.env"
VAR1=0666 VAR2=N VAR3=0666 MIN=3 VAR4=4 VAR5=N
VAR6=FASTPATH
VAR7=5 VAR8=86400 VAR9=Y
VAR10=0 VAR11=1 VAR12=0
VAR13="0"
"Server2" srvgrp="group2" srvid=20
CLOPT="-A -r -e /path/logfile -o /path/stdout"
VAR1=0666 VAR2=N VAR3=0666 MIN=2 VAR4=4 VAR5=N
VAR6=FASTPATH
VAR7=5 VAR8=86400 VAR9=Y
VAR10=0 VAR11=1 VAR12=0
=================================================

From above file I need to extract the value of MIN variable (in order to get the no. of occurences of that instance) & store it in a file along with the first string & second string

Desired output :
============
6 Server1 group1 ---> Since there are 2 instances each with MIN=3
2 Server2 group2

One way of doing it with awk:

Code:

BEGIN { RS="\n^\""; FS="\n"; }

{
        # extract different values for server group and MIN
        match($1, /Server[0-9]+/, out); server = out[0]
        match($1, /group[0-9]+/, out); group = out[0]
        match($0, /MIN=([0-9]+)/, out); min = out[1]

        # add value of MIN to array result[Server_xx group_yy]
        result[server " " group] += min
}

# print array contents
END { for (i in result) printf "%d %s\n", result[i], i }

I am getting following error when tried to execute the statement:
=================================================
awk 'BEGIN { RS="\n^\""; FS="\n"; }
> {
> match($1, /Server[0-9]+/, out); server = out[0]
> match($1, /group[0-9]+/, out); group = out[0]
> match($0, /MIN=([0-9]+)/, out); min = out[1]
> result[server " " group] += min
> }
> END { for (i in result) printf "%d %s\n", result[i], i }' inputfile
syntax error The source line is 3.
The error context is
match($1, >>> /Server[0-9]+/, <<<
awk: The statement cannot be correctly parsed.
The source line is 3.
================================================
And when I execute it with " then I am getting following error :
awk "BEGIN { RS="\n^\""; FS="\n"; }
> {
> match($1, /Server[0-9]+/, out); server = out[0]
> match($1, /group[0-9]+/, out); group = out[0]
> match($0, /MIN=([0-9]+)/, out); min = out[1]
> result[server " " group] += min
> }
> END { for (i in result) printf "%d %s\n", result[i], i }" inputfile
ksh: 1: parameter not set

Pls suggest

Code:

awk '
  /Server/ { split ($2, tmp, "="); ar = $1" " tmp[2]}
 /MIN/ { split ($4, count, "=")
        total[ar] = total[ar] + count[2]
       }
  END {
        for (a in total) {
         print a " " total[a]
        }
  }' <Filename>

Thanks aju,

But I need the count to be displayed along with servername & group. I am not getting the correct count in this case. As I mentioned earlier, if MIN=2 for server1, group1 & MIN=3 again for server1, group1 then the count should be 5

do u want output like

Code:

"Server1" "group1" 6
"Server2" "group2" 2

yup...exactly