topic Re: Unable to read special characters from file with tHttpRequest in Talend Studio

Unable to read special characters from file with tHttpRequest

Anonymous — Sat, 16 Nov 2024 06:43:51 GMT

Im reading a csv file hosted on SharePoint with tHttpRequest but I dont know how to read the accents and special caracters.

I'm getting an output like N�Demande ;Dur�e ;r�sultat

I used headers section to add "Content-Type" : "Charset=ISO-8859-1"

I tried also to use tjava component to read the input as ByteArrayOutputStream and used row1.ResponseContent.getBytes("ISO-8859-1")

but I'm still getting an output like N?Demande ;Dur?e ;r?sultat

I changed the Charset to "UTF-8" but it's giving me the same result

Do you have any idea please about how to get the right caracters with tHttpRequest ?

Re: Unable to read special characters from file with tHttpRequest

Anonymous — Tue, 29 Jan 2019 16:26:17 GMT

Hi,

Could you please verify whether the original file is having the data in right manner with UTF-8?

There is a possibility that the data is already changed in the source file itself.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Unable to read special characters from file with tHttpRequest

Anonymous — Tue, 29 Jan 2019 17:50:50 GMT

thank you @nthampi for your reply

The data in the original file was written in the right manner , the file is encoded in "ANSI"

If I change the encoding of my file to UTF-8 I can get the data with the right special caracters.