I’m importing data from an Excel generated CSV. (I have no options for how the file is generated.) Certain characters come through garbled.
After trying out different snippets, I found that the following line of code will remove all of the offending characters :
$text = preg_replace('/[^(\\x20-\\x7F)]*/','', $text);
The problem is that em dashes, some white spaces, and possibly a few other characters are removed and should be replaced.
The Wikipedia page maps the character set, but I don’t know how to use this chart in PHP in str_replace or pre_replace.
Can anyone provide some assistance?
Thank You E.