How to prevent Rails from encoding entities in FasterCSV output

Question

I'm using FasterCSV to produce CSV output of my reports in a Rails 3 application. Here's a code snippet:

<%= FasterCSV.generate do |csv|
  @groups.each do |b|
    record = [ b.group, b.organization_name, b.status, b.comments ]
    csv << record
  end
end 
%>

When FasterCSV includes an empty string, it uses a pair of empty double quotes.

Unfortunately, Rails 3 is encoding those quotation marks as entities, which doesn't work very well with Excel. Here's what my CSV output looks like (when b.comments is nil or an empty string):

Rafeland,Rafe Organization,Submitted,&quot;&quot;

What's the generally accepted method for preventing Rails from encoding those entities? I know about the raw method, but it doesn't take a block that I can put the CSV generation into.

the Tin Man · Accepted Answer · 2020-02-04 01:18:18Z

5

I would recommend generating a file (perhaps merely a Tempfile) and serving that, but if you want to continue doing it your way, then you need to tell Rails that the entire CSV is HTML-safe. Assuming FasterCSV.generate returns a normal String, then simply tack on html_safe:

<%= FasterCSV.generate do |csv|
  ...
end.html_safe
%>

edited Feb 4, 2020 at 1:18

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

answered Jul 15, 2011 at 19:30

Jeremy Weathers

2,5541 gold badge16 silver badges24 bronze badges

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

2 Comments

Rafe Over a year ago

I didn't know you could take a method call onto the end of a block like that. Ruby is cool.

Matthew Clark Over a year ago

I didn't know that either. Woohoo!

Collectives™ on Stack Overflow

How to prevent Rails from encoding entities in FasterCSV output

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related