Shell Programming and Scripting

Hostname
Value1=abc
Value2=def
Value3=xyz
Hostname1
Value1=abc1
Value2=def1
Value3=xyz1
Hostname2
Value1=abc2
Value2=def2
Value3=xyz2
|
|
|

Hostname          value1                  value2                  value3
Hostname          abc                         def                         xyz
Hostname1        abc1                      def1                      xyz1
Hostname2        abc2                      def2                      xyz2

awk '
BEGIN   {print "Hostname value1 value2 value3"}
        {sub (/^.*=/,_)
         printf "%s%s", $1, NR%4?" ":"\n" 
        }
' file

#!/bin/bash
echo "hostname value1 value2 value3" > result.csv
a=`cat $1 | wc -l`
echo $a
b=`expr ${a} / 4`
echo $b
i=1
while [ $i -le $b ]
do[/FONT]
echo "Inside loop"
echo $i
c=`expr ${i} \* 4`
echo "c=$c"
cat $1 | head -n $c | tail -n 4 > t2.csv

 awk '
BEGIN   {print "Hostname value1 value2 value3"}            #### In starting of any operation print Hostname value1 value2 value3 as headers as per your request
        {sub (/^.*=/,_)                                    #### Substitute any line which has match from starting to till = with NULL
         printf "%s%s", $1, NR%4?" ":"\n"                  #### then print the values of $1 as first string and as second string print space " " when NR%4 is having some values and if NR%4 has no values then print new line.
        }                                                       Means we are only printing new line after 4th line. operators ? means when a condition is TRUE then follow the instructions after that operator and instructions proceeding : operator are being
'                                                               done when condition is FALSE.

awk -F'=' 'BEGIN{print "Hostname value1 value2 value3"}{printf("%s%s",$NF,NR%4?" ":RS)}' file