UNIX for Dummies Questions & Answers

Hi I have a file like this:

Code:

 
a=1
b=2
c=3
a=4
b=2
d=3
a=3
c=4

How can I change this to csv format

Code:

a,b,c,d
1,2,3,,
4,2,,3
3,,4,,

Moderator's Comments:

Please use code tags next time for your code and data. Thanks

Welcome sandip_2014,
I have a few to questions pose in response first:-Most importantly, What have you tried so far?

it would be useful to know the relationship between the input and output. There could be many ways of getting the output from the input, but only one that matches the way that will make it reusable for you. 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.


kind regards,
Robin

Nope this is not home work..

I have tried using awk

Code:

awk -F"=" 'BEGIN {print "a,b,c,d";}/a/{line=line$2","}/b/{line=line$2","}/c/{line=line$2","}/d/{line=line$2;print line}' test.log>test.csv

But that is not working.... the csv is coming jumbled up

I am solaris10 sparc

Can you explain the logic of the conversion you want to make? I don't see it clearly from the input-->output you have shown.


Robin

Hi Robin

The input file is

Code:

a=1
b=2
c=3
a=4
b=2
d=3
a=3
c=4

and I want the output as a csv

Code:

a,b,c,d
1,2,3,,
4,2,,3
3,,4,,

In the AWK I tried to use = as delimiter and print all data next to it with a comma separator but that did not help.

Please use code tags as required by forum rules!

Is it always 4 columns, i.e. d is the last one? And, a new line always starts with an a= entry? Or how to tell where line switches are?

RudiC

Yes.

It always ends in

Code:

d

and starts with

Code:

 a=