How do I generate a CSV with ANSI encoding using Ruby?

Question

Currently I'm generating a CSV with UTF-8 encoding from my administrate ui. But swedish letters "åäö" is not shown correctly in excel or in the label printer programs (P-touch Editor 5.4 & Dymo Connect) I'm using.

After talking to their support I've been told the CSV needs to be ANSI encoded. How do I do that?

My code:

  def to_csv
    attributes = %w{full_name street_address postal_code city}

    CSV.generate(headers: true, col_sep: ",") do |csv|
      csv << attributes

      orders.all.each do |order|
        csv << attributes.map{ |attr| order.address.send(attr) }
      end
    end
  end

There is no such thing as an "ANSI encoding". You need to ask them which precise encoding they need. — Jörg W Mittag
– Jörg W Mittag, Commented Aug 22, 2022 at 19:36

Daniel Rikowski · Accepted Answer · 2022-08-22 16:17:53Z

1

By default CSV uses Encoding.default_external as encoding, most likely this is UTF-8.

In your case you have to override it, but first you need to know which ANSI encoding you actually need. (What is ANSI format?)

Most likely you can use Windows-1252 or ISO-8859-1.

Then you can set the external encoding of the CSV string like this:

CSV.generate(headers: true, col_sep: ",", encoding: Encoding::ISO_8859_1)
CSV.generate(headers: true, col_sep: ",", encoding: Encoding::WINDOWS_1252)

Strings work, too:

CSV.generate(headers: true, col_sep: ",", encoding: 'ISO-8859-1')

answered Aug 22, 2022 at 16:17

Daniel Rikowski

72.8k63 gold badges257 silver badges336 bronze badges

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

Collectives™ on Stack Overflow

How do I generate a CSV with ANSI encoding using Ruby?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related