[SOLVED] How to add quotes between words in a cvs file?

dv502 · 03-08-2010, 08:37 PM

Hello linux fans

I exported a spreadsheet file into cvs format.

The cvs file is formatted this way

field1,field2,field3,..etc

I want it to be in a Quote delimited format like so

"field1","field2","field3",..etc

I goggled online but could not get the right answer.

If you know please post.

Thanks in advance

pixellany · 03-08-2010, 10:16 PM

CSV (Comma-Separated Variables)

In the example you show, the double-quotes are not delimiters----a delimiter is a character that separates fields. You would not--for example-- be able to manipulate fields by specifying " as the delimiter.

Regardless, try this to install the quotes per your example:

Code:

sed 's/\([^,]*\)/\"\1\"/g' filename > newfilename

If you really want the " to be the delimiter, then:

Code:

sed 's/,/\"/g' filename > newfilename

dv502 · 03-08-2010, 10:34 PM

Hey pixellany,

Thanks for the code. It worked like a charm.