Encoding issue with single and double quotes when exporting CSV file

[cara_ay]

Hi, I'm trying to export a JSON file using tFileDelimitedOutput. There are strings in the file which has single and double quotes and I need these to remain in the exported file. However, the double and single quotes are replaced with question marks when exported using the tFileDelimitedOutput.

I've tried changing the 'Encoding' options but none of them seem to work either.

Is there a way where I can export this so that the single and double quotes remain in the exported file?

Thanks!

[Anonymous]

Hi

I can't reproduce the issue on v7.3.1, which version of studio are you using? Does the value display correctly with tLogrow?

Regards

Shong

[cara_ay · Accepted solution]

Hi Shong,

Thanks for the speedy response 🙂

I've actually just tried again by setting the encoding to CUSTOM = "UTF-16". This seems to have fixed the issue 🙂

[Anonymous]

Hello,

Great your issue is fixed, have you thought of entering our competition?

https://community.talend.com/s/blog/aGn5b000000CaZw/getting-smart-about-talend-tip-of-the-day

Best regards

Sabrina