Cannot Decode , HTML to Comma about htmlentities

[threedaymonk]

I can't reproduce this: , is decoded to , for me.

What else is in your project? What is self.Long_Description? That's a really strange name for a Ruby method (it shouldn't normally start with a capital letter), which makes me wonder about the rest of the environment.

I'm closing this for now; please reopen it if you can make a minimal test case that demonstrates the problem.

[Jonathan-Garber]

Thanks
You can leave this closed. I went a different direction and resolved the issue myself.

[Jonathan-Garber]

Ok so I actually came back to using HTMLEntities for decoding and I still have this same error.

def test
  require 'htmlentities'
  coder = HTMLEntities.new
    product = Product.where(Product_Number: item).take
    number = coder.decode(product.Product_Number)
    name = coder.decode(product.Product_Name)
    manufacturer = coder.decode(product.Manufacturer)
    desc = coder.decode(product.Long_Description)
end

All entities are properly replaced except ,

All products are imported from a CSV sheet to the table. Long_Description is t.text and contains the plain text description of the item. The CSV Long_Description is plaintext with the html encoded already.

So I am decoding them on the fly. I rather decode them before saving to the database but I couldn't make that work properly either. I had the same issue with the , remaining encoded

Why would it work on all other entities except that one? I am totally lost on this.

[Jonathan-Garber]

If it helps I did some more testing tonight at I found a description like this

Some Words Here, More Words Here

Which gives me

Some Words Here, More Words Here

I also found its not working for me on

"

I am beginning to think its due to how the descriptions are for some of these items. I might be stuck with fixing them by hand once they are added in from the CSV sheet.

[threedaymonk]

That is actually working as it's supposed to: you've got double-escaped text there (→ = decode, ← = encode):

, ⇄ , ⇄ ,

If you decode twice, it should give you the results you expect.

[Jonathan-Garber]

hrm.. It's a shame I don't have control over how the content is on these CSV Sheets.

However double decoding seems to have fixed it properly. Thank you for that advice. I simply didn't think to try double decoding it.

Thanks again