Remove characters like Â from synopsis in Catalog

pacd97867 · 07-13-2017, 06:58 AM

When I create a catalog and view the created csv file, often times the book description includes special characters. Example is:

Example 1
A mother desperate for the truth. A daughter hiding a terrible secret.Melanie OakÂ*appeared to have the perfect.

Example 2
This is friends-to-lovers romanceâ€¦but it's in the science-fiction story line where Cole really shines

Example 3
Alicia worries that her young daughter Jenny's summer will be

How do I solve this? There are times I use the csv to read the desc, specifically on my phone etc.

Thanks so much in advance.

kovidgoyal · 07-13-2017, 10:34 AM

Make sure whatever you are using to read the CSV files, reads them using the UTF-8 character encoding, which is what calibre generates.

pacd97867 · 07-13-2017, 11:26 AM

Thanks!

07-13-2017, 06:58 AM	#1
pacd97867 Junior Member Posts: 3 Karma: 10 Join Date: Aug 2010 Device: Sony EReader 505	Remove characters like Â from synopsis in Catalog When I create a catalog and view the created csv file, often times the book description includes special characters. Example is: Example 1 A mother desperate for the truth. A daughter hiding a terrible secret.Melanie OakÂ*appeared to have the perfect. Example 2 This is friends-to-lovers romanceâ€¦but it's in the science-fiction story line where Cole really shines Example 3 Alicia worries that her young daughter Jenny's summer will be How do I solve this? There are times I use the csv to read the desc, specifically on my phone etc. Thanks so much in advance.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bulk Edit Remove Leading Characters	Rainybeet	Library Management	5	08-21-2014 09:18 PM
Regex to remove the first 4 characters	nynaevelan	Library Management	3	07-19-2014 07:41 PM
Can I remove the first x characters from titles in bulk?	statusneo	Library Management	2	06-11-2014 12:20 PM
Forcing screen refresh in kterm to remove ghost characters?	pete330	Kindle Developer's Corner	3	09-01-2013 11:16 AM
Catalog generation fails when title contains specific accented characters	riki	Library Management	8	08-24-2011 03:41 AM

07-13-2017, 10:34 AM	#2
kovidgoyal creator of calibre Posts: 44,565 Karma: 24495948 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Make sure whatever you are using to read the CSV files, reads them using the UTF-8 character encoding, which is what calibre generates.

07-13-2017, 11:26 AM	#3
pacd97867 Junior Member Posts: 3 Karma: 10 Join Date: Aug 2010 Device: Sony EReader 505	Thanks!

Advert