need a text parser

[sfaizan]

i need a simple text parser which can parse a data file created by a softwre so that i can export it to my mysqldb,, datafile created as one record per line with different number of fields.

e.g datafile contains following.

a=1, b=3, c=4
a=1, c=55, d=abcd
a=5, b=hello, c=99, d=help


now i want to parse them as
1,3,4
1,55,abcd
5,hello,99,help

i want to remove field name and make data as comma seperated so that i can export them to my db. or anyother way to export these fields to mysql where field names are same as a,b,c,d.
a,b,c and d are fields.

[coopstah13]

look on the web for awk tutorials, you should find what you need

[sfaizan]

I tred awk but i dont know how to use multi dimentioal arrays for split. I can split single value e.g a=1 but dont knw how to with multiple values in single record.

any sugession ?

[i92guboj]

A simple sed line should do:

sed -e 's/ *[a-zA-Z]*=//g' filename.txt

[sfaizan]

i got rid of the left side and got the results with awk and sed using

sed 's/[^,]*=//g'

but one poblem. On monotor it displays correclty but when at the end i try ti put them in a file using >> filename , there i am getting "\" after every field and that file 'filename'.

eg.

12\,hello\,99
2\,22\,abcd

how to remove the trailing '\'