Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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