Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
DBS1
Contributor III
Contributor III

Unicode conversion in talend

Hi

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

Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi

Try this on a tJavaRow after returning the response string.

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

 

Regards

Shong

View solution in original post

2 Replies
Anonymous
Not applicable

Hi

Try this on a tJavaRow after returning the response string.

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

 

Regards

Shong

DBS1
Contributor III
Contributor III
Author

Hi Shong

 

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

 

Thanks

Dhanoop B S