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?
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.