Shell Programming and Scripting

Hi

I have a file having the values like below

----------------------------

Code:

.set A
col1=”ABC”
col2=34
col3=”DEF”
col4=”LMN”
col5=25
.set A
.set B
col1=55
col3=”XYZ”
col4=”PQR”
col5=66
.set B
.set C
col2=”NNN”
col5=”MMM”
.set C

---------------------------------------------
I want the output file as below

-------------------------------------------

Code:

col1;col2;col3;col4;col5
ABC;34;EDF;LMN;25
55;;XYZ;PQR;66
;NNN;;;MMM

----------------------------------------------
So can someone help me how to get the desired output using UNIX Shell scripting.

Welcome Suneel Mekala,

I've moved this thread to a general forum rather than the "Contact Administrators" one. Please consider where you are posting. Additionally, please wrap code and data input/output in CODE tags, like this:- to produce the following (fixed character width, space respected):-

Code:

This is my code

It makes it far easier to read. I have adjusted your submission for you this time.


As to your question, I have a few to pose in response first:-Most importantly, What have you tried so far?

There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.


We're all here to learn and getting the relevant information will help us all.



Thanks, in advance,
Robin
Lancashire, UK