Shell Programming and Scripting

 
:> cat my_emp
Employee array(0)
Name :  Albert
No : 1234
Address: stationstraat
City: Utrecht
Employee array (1)
Name : Kouwen
No : 1256
Address: stationstraat
City: Amsterdam
Employee array (2)
Name : Peter
No : 9256
Address: atomweg
City: Groningen
Employee array (10)
Name : Claudio
No : 9257
Address: Beatrixlaan
City: DenHaag

 
Name  | No| City
Alber |1234| Utrecht
Kouwen|1256| Amsterdam
Peter|9256| Groningen
Claudio|9257| DenHaag

 
awk -F"= " '/Name/{if(s){print s}s=$NF}
/No/ || /City/{s=s "\t" $NF}
END{print s}' my_emp

 
Name :  Albert  No : 1234       City: Utrecht
Name : Kouwen   No : 1256       City: Amsterdam
Name : Peter    No : 9256       City: Groningen
Name : Claudio  No : 9257       City: DenHaag

awk '
/^Name/{n=$NF}
/^No/{n=n "|" $NF}
/^City/{print n "|" $NF}
' file