problem while importing post/post title that contain the ' character

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: https://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 !

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.

Also, I just realized that the first post replaced my HTML entities with their equivalents despite encoding the ampersands, so it looks strange.

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).