converting .txt to comma delimeted file

Shell Programming and Scripting
1

Dear all,

I have a file with 5L records. one of the record in the file is as shown below.
MARIA THOMAS
BASIL
1000 FM 1111 MD

GHANA
YY 77354 4774
99999999 1234567

I need to convert this record in below format

"","","","","MARIA","THOMAS","BASIL","","1000 FM 1111 MD","STE B","","","GHANA","YY","77354","4774",""1234567"99999999"
,"","","","","","","","","","","",""

Please suggest....Thanks in advance.

2

Here is a start for you:

awk '
        { a[NR%11]=$0 }
        !NR%11 {
                # if NR%11 is 0, then we have a complete record, so print it
                # split the name into the b array
                split(a[1],b)
                print "\"\",\"\",\"\",\"\",\"" b[1] "\",\"" b[2] "\",\"" a[2]
        }
' inputfile

It only does the first few fields, but you should be able to figure out the rest from that.