Shell Programming and Scripting

Attribute                            Value 
---------------                   ---------------

Total Capacity                     500 GB 
Utilization                            10 % 
Used Capacity                      50 GB

Total Capacity   Utilization     Used Capacity 

   500 GB            10%              50 GB

$ cat totalcap.awk

# Field separator is two or more spaces
# ORS="\r\n" makes the text Windows-readable,
# omit it to make an ordinary flatfile.
BEGIN { FS="   *"; ORS="\r\n"     }
# Ignore first three lines, then store in array, keep order in O
NR>3 { sub(/ *$/, ""); A[$1]=$2; O[++L]=$1 }

END {
        S="";   for(N=1; N<=L; N++) S=S","O[N];
        print substr(S, 2);
        S="";   for(N=1; N<=L; N++) S=S","A[O[N]];
        print substr(S, 2);
}

$ awk -f totalcap.awk data

Total Capacity,Utilization,Used Capacity
500 GB,10 %,50 GB

$

command | awk -f totalcap.awk > outputfile

# Field separator is two or more spaces
BEGIN { FS="   *";      OFS=",";        ORS="\r\n"      }
# Ignore first three lines, then store in array, keep order in O
NR>3 { sub(/ *$/, ""); A[$1]=$2; O[++L]=$1 }

END {
        print "Total Capacity", "Utilization", "Used Capacity";
        print A["Total Capacity"], A["Utilization"], A["Used Capacity"];
}