I have a database that has been populated with content pasted out of MS Word, and is full of special characters -- em dashes, curly quotes, curly apostrophes, etc. Now I'm generating plain text email summaires out of the database and of course those special chars appear as garbage chars in the emails.
How can I filter the extracted text and transform these characters into plain text equivalents? Is there a builtin function for this, external class available, or do I need to try and hack it out from scratch?
Thanks,
Scot