topic Unicode conversion in talend in Talend Studio

Unicode conversion in talend

DBS1 — Fri, 15 Nov 2024 21:30:08 GMT

I am extracting JSON data from API using tRest component in Talend. I am using tExtractField Component to extract the required fields.

I could see that while extracting the data from API I am getting the Unicode characters instead of their actual values. for few of the special characters.

Please let me know how to convert these Unicode characters into actual values. I am using UTF-8 encoding for the tFileOutputDelimited Component.

eg:

From API: This is an ’ example

After processing in Talend:

This is an \u2019 example

Thanks

Re: Unicode conversion in talend

Anonymous — Fri, 11 Aug 2023 03:23:28 GMT

Try this on a tJavaRow after returning the response string.

output_row.Body=new String(row2.Body.getBytes("UTF-8"));

Regards

Shong

Re: Unicode conversion in talend

DBS1 — Fri, 11 Aug 2023 08:39:35 GMT

Hi Shong

After using the above code, everything is getting converted to Bytes

Thanks

Dhanoop B S