Forum Discussion
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:
- Apostrophe’s are incorrectly output, example: women’s becomes women’s
- “bad” and “wild” becomes “bad†and “wildâ€
- 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?
Hi @vincenr
Good day, this are extended characters/ascii code which maybe be viewed in excel or other app as special character
So, what do you want to do with this characters?
Here are some options that you can do (1) replace the extended characters with the regular ones or (2) just remove all those characters
$the_text_description.replace(/”|“|‘|’|–|—/g, m=> match m { '”'=> '"', '“'=> '"', "‘"=> "'", "’"=> "'", "—"=> "-", "–"=> "-" }) or you can also totally removed those characters $the_text_description.replace(/”|“|‘|’|–|—/g, '')
Thanks,
MM