Forum Discussion

vincenr's avatar
vincenr
New Contributor III
3 years ago

String text in JSON output incorrectly using csv parser/formatter to csv

I’ve got the following text in a description field in my raw JSON file, where the double quotes are obviously escaped. How can I change settings in the JSON formatter and/or the CSV parser/formatter...
vincenr's avatar
vincenr
New Contributor III
3 years ago
Copy Link

So, the site I found fixed the issue with my text for the description field getting spread incorrectly across three columns, but now I have roughly 250 rows out of about 7000 rows where the description is messed up, with characters like apostrophes displayed incorrectly on the csv output.

Issues:

  1. Apostrophe’s are incorrectly output, example: women’s becomes women’s
  2. “bad” and “wild” becomes “bad” and “wildâ€
  3. An em-dash in a text like P—GRK becomes P—GRK

Can someone help me with this?

New Note: I discovered if I open my csv in notepad++ the characters all appear to be correct and not messed up as above. So, I really don’t know what to do now.

Can someone please help me with this?