Ruby Read and Write CSV with Quotes

Question

I'd like to read in a csv row, update one field then output the row again with quotes.

Row Example Input => "Joe", "Blow", "[email protected]"
Desired Row Example Output => "Joe", "Blow", "[email protected]"

My script below outputs => Joe, Blow, [email protected]

It loses the double quotes which I want to retain.

I've tried various options but no joy so far .. any tips?

Many thanks!

require 'csv'

CSV.foreach('transactions.csv',
            :quote_char=>'"',
            :col_sep =>",", 
            :headers => true, 
            :header_converters => :symbol ) do |row| 

row[:customer_email] = '[email protected]'

puts row

end

Answer 1

Quotes in CSV fields are usually unnecessary, unless the field itself contains a delimiter or a newline character. But you can force the CSV file to always use quotes. For that, you need to set force_quotes => true:

CSV.foreach('transactions.csv',
            :quote_char=>'"',
            :col_sep =>",", 
            :headers => true, 
            :force_quotes => true,
            :header_converters => :symbol ) do |row| 

Answer 2

You can manually add them to all your items

Hash[row.map { |k,v| [k,"\"#{v}\""] }]

(edited because I forgot you had a hash and not an array)