'How can I add quotation marks to fields in a CSV file?

I've got a CSV file like

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

I'd like to include quotation marks to have it like:

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

What's the fastest way to do it? I will implement it in a cronjob.

csv awk sed

Solution 1:^[1]

This might work for you (GNU sed):

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

It's often neater to use a language with a CSV library for CSV data:

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

With awk:

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

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.