In rails, given an array of objects, how can I output a CSV list instead of to_json?

Question

If I do:

Contact.select('email').first(1000).to_json

I get a JSON response with emails... How can I get just a CSV of emails? [email protected], [email protected]

I'm trying to do this from rails console.

Thanks

fl00r · Accepted Answer · 2011-09-11 21:52:51Z

2

Contact.select('email').map(&:email).join(", ")

answered Sep 11, 2011 at 21:52

fl00r

83.7k33 gold badges222 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KARASZI István · Accepted Answer · 2011-09-11 21:53:14Z

2

You can install this plugin to have the to_csv method. Or you can implement it yourself.

I would vote for the prior, because if you'll need to print out names instead of emails you should implement the escaping as well, and this would be there for you by the plugin.

Update:

Oh I have not realized that you need only the mails, with this plugin you could do the following:

@emails = Contact.select('email').first(1000).map(&:email)

respond_to do |format|
  format.html
  format.xml { render :xml => @emails }
  format.csv { send_data @emails.to_csv }
end

answered Sep 11, 2011 at 21:53

KARASZI István

31.5k9 gold badges106 silver badges133 bronze badges

Collectives™ on Stack Overflow

In rails, given an array of objects, how can I output a CSV list instead of to_json?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related