In some rare cases, users who import items from CSV will see special characters, such as � in their text.
Solution
- In the Import from CSV tool, select the CSV file, you will be presented with a text box with the problematic text
- From the Admin Tools page text box, highlight the entirety of the text that includes the special characters
- Copy, and paste the text into your text editor of choice (we reccomend Notepad++)
- Use the Find And Replace function within your text editor as follows: FIND: (paste special character in to the find field) REPLACE: (include a single space in your replace field)
(NOTE: DO NOT SAVE THIS TEXT FILE) - After all instances of the special characters have been replaced, copy the entirety of the text, copy, and past paste it BACK into the Admin Tools Import text box
- Continue with the import as usual.
...