Moderator
Helen Hou-Sandi
(@helen)
Core Lead Developer and 4.0, 4.7, and 5.6 Release Lead
I’ve had problems with special characters truncating imports in the past, so what I’ve done is to run a find-and-replace on the CSV in a text editor and replace quotes and other special characters (e.g. diacritics/accented letters) with their HTML entities. So, for instance, replacing ‘ with ' and ” with " . See: http://www.elizabethcastro.com/html/extras/entities.html
problem is its happening with all special characters like
£ é ” – * ä etc how can sort out this issue !
Thanks in advance !
Moderator
Helen Hou-Sandi
(@helen)
Core Lead Developer and 4.0, 4.7, and 5.6 Release Lead
As I said in my previous post, you need to replace all special characters with their equivalent HTML entity.
- £ =
£
- é =
é
- ” =
"
- ä =
ä
* is not a special character, but if it is giving you problems (which it shouldn’t), try replacing it with something noticeable like ASTERISK, noting where it appears, and then go back and fix it manually after import.
Moderator
Helen Hou-Sandi
(@helen)
Core Lead Developer and 4.0, 4.7, and 5.6 Release Lead
Also, I just realized that the first post replaced my HTML entities with their equivalents despite encoding the ampersands, so it looks strange.
Plugin Contributor
dvkob
(@dvkob)
While Helen’s solution works too, you shouldn’t need to do this if you save your file with UTF-8 encoding (mentioned in the plugin’s FAQ) and your file is properly escaped (see the examples in the plugin’s directory).