Shell Programming and Scripting

 
cat tabular.txt
 
User 1 Details :-
First Name = Tom
Middle Name =
Last Name = Hanks
Age = 40
Address =
User 2 details :-
 
First Name = Mike
Middle Name =
Last Name = Tyson
Age = 50
Address =

 
First Name Middle Name Last Name Age 
Tom                           Hanks       40 
Mike                           Tyson       50

awk -F " = " '
BEGIN {printf("First Name Middle Name Last Name Age\n")}
/^ *$/ {if(f m l a != "") {
                printf("%-10s %-11s %-9s %3s\n", f, m, l, a)
                f = m = l = a = ""
        }
}
$1 == "First Name" {f = $2}
$1 == "Middle Name" {m = $2}
$1 == "Last Name" {l = $2}
$1 == "Age" {a = $2}
END {if(f m l a != "") printf("%-10s %-11s %-9s %3s\n", f, m, l, a)}
' tabular.txt

First Name Middle Name Last Name Age
Tom                    Hanks      40
Mike                   Tyson      50

awk -F= '$0~/=/{if(++x<5)printf $1; b[y++]=$2}
END{printf"\n";for(i=0;i<=y;i+=5){printf "%-10s%-12s%-10s%4s\n",b[i],b[i+1],b[i+2],b[i+3]}}' infile