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:
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
OK, I will try that period. Thank but please leave this ticket open until after I verify if it works.
I’d rather see the syntax for how to only include a-zA-z0-9.()’
How would the syntax work for CRLF? That is, if I only want to replace
CRLF with a space in a field?
Never mind, I figured it out.
