How to add quotation marks to fields in a CSV file?

Question

I have a CSV file like

Brand,Type,Color Porsche,Sport,Red BMW,Coupe,Blue

I would like to add quotation marks so that it is like this:

 "Brand","Type","Color" "Porsche","Sport","Red" "BMW","Coupe","Blue"

What is the fastest way to do this? I will implement this in a cronjob.

+4

Adam lesniak Jun 17 '13 at 22:22

4 answers

This may work for you (GNU sed):

 sed -r 's/[^,]+/"&"/g' file

+5

potong Jun 18 '13 at 5:53

With awk :

 awk '{gsub(/[^,]+/,"\"&\"")}1' file.csv

+2

jaypal singh Jun 18 '13 at 0:13

It is often not recommended to use a language with a CSV library for CSV data:

 ruby -rcsv -ne 'puts CSV.generate_line(CSV.parse_line($_), :force_quotes=>true)'

+1

glenn jackman Jun 17 '13 at 23:25

perreal · Accepted Answer · 2013-06-17T22:27:09+0000

Using sed:

 sed -e 's/^\|$/"/g' -e 's/,/","/g' input