sed Pattern to Insert Comma between double Quotes

Question

I am very new to sed Regex pattern and stuck with a requirement. I have few Records which i am pulling from Database

"Name" "Age" "From ABC" "12"

now I am exporting it to CSV with Comma Separated i am using 's/[[:space:]]\+/,/g' This Regex

Which is giving me the Result as

"Name","Age","From,ABC","12"

Which is fine except the Third Column where it has inserted , for space now i want to insert , in between double quotes.

Can any One Guide me for the same?

With 's/"[[:space:]]\+"/","/g' Regex i Am able to get "Name","Age","From,ABC","12" But its is failing when i have "Name","","From,ABC","12" it gives "Name",",","From,ABC","12"

Is there any other way to counter this?

Answer 1

Replace " " with ",":

sed 's/"[[:space:]]\+"/","/g'

Edited to catch more than one space

Answer 2

I'd do this:

echo \"Name\"     \"Age\" \"From ABC\" \"12\" | sed -e 's/"[[:space:]]\+"/","/g'

which returns

"Name","Age","From ABC","12"

edit

if you want have empty strings " " also matched, then you could do this:

$ echo \"Name\" \" \"    \"Age\" \"From ABC\" \"12\" | sed -e 's/\("[[:alnum:][:space:]]*"\)/\1,/g' \
    -e 's/",[[:space:]]\+/",/g' \
    -e 's/,[[:space:]]\?$//g'

which returns

"Name"," ","Age","From ABC","12"

The first rules matches strings in quotes (that also may be empty), the second rule removes the spaces between , and the next ", the third rules removes the last ,.