CSV export of smart quotation becomes ’

[Barrie Treloar]

The joys of pasting content from word mean you get "smart" quotation marks.

When the Notes field of my Requirement contains
U+2019 : RIGHT SINGLE QUOTATION MARK {single comma quotation mark}

and I CSV Export with Code Page 65001 (UTF-8) it gets translated to
’

Does anyone know how to solve this issue?

[Sunshine]

I reported this as a bug some time ago but never got a response. Support has gone down hill over the years as I used to get an acknowledgement as to whether it was a bug and a work around within a day.
The easiest thing I can suggest as a work around is to do a search and replace in the CSV file with excel.
Noting that is only one of many characters that get corrupted during export to UTF-8 from Windows 1252 the default character set for Windows.

Another option in the Notes editor, avoid using:
- Smart quotes
- Bulleted lists
- Special symbols (•, –, …)
You can do this by not copying and pasting from word but paste into notepad then copy from notepad.

[Barrie Treloar]

Thanks.

I suspected it was YAEAB.

I've ditched attempting to do CSV import/export or copy-paste to/from Word.

If I get around to it this will require scripting outside of EA to integrate between EA and Word.