topic Re: Encoding issue with single and double quotes when exporting CSV file in Talend Studio

Encoding issue with single and double quotes when exporting CSV file

cara_ay — Fri, 15 Nov 2024 23:44:56 GMT

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!

Re: Encoding issue with single and double quotes when exporting CSV file

Anonymous — Mon, 13 Sep 2021 04:59:33 GMT

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

Re: Encoding issue with single and double quotes when exporting CSV file

cara_ay — Mon, 13 Sep 2021 05:03:05 GMT

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 🙂

Re: Encoding issue with single and double quotes when exporting CSV file

Anonymous — Mon, 13 Sep 2021 07:44:25 GMT

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