CSV apostrophe export bug

Hi all,

Recently found that when exporting as CSV, apostrophes in string data can become question marks. Obviously a very niche issue, but thought I should flag it. Does anyone have any ideas why?

EasyMorph - CSV apostrophe test.morph (1.7 KB)

Hi Alistair,

That’s because that symbol in your expression is not an apostrophe. It’s a Right Single Quotation Mark U+2019 which is not represented by the ASCII encoding. You can either replace all of those characters with actual apostrophes (by hand or by a Modify column transformation and replace() function) or choose one of the supported Unicode encodings.