Remove characters like Â from synopsis in Catalog

pacd97867 · 07-13-2017, 05: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, 09: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, 10:26 AM

Thanks!

07-13-2017, 05: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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

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

07-13-2017, 09:34 AM	#2
kovidgoyal creator of calibre Posts: 31,130 Karma: 7757719 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, 10:26 AM	#3
pacd97867 Junior Member Posts: 3 Karma: 10 Join Date: Aug 2010 Device: Sony EReader 505	Thanks!

Advert