Convert non-UTF8 encoded files to UTF-8 encoded format

Four Stars

Convert non-UTF8 encoded files to UTF-8 encoded format

Is there a way to Convert non-UTF8 encoded files to UTF-8 encoded format for Hadoop to parse the file efficiently
And replace the hexadecimal Field and Record delimiters to proper format in UTF-8 encoding? Can you illustrate thru an example?
Moderator

Re: Convert non-UTF8 encoded files to UTF-8 encoded format

Hi,
Have you checked component TalendHelpCenter:tChangeFileEncoding which transforms the character encoding of a given file and generates a new file with the transformed character encoding.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Convert non-UTF8 encoded files to UTF-8 encoded format

Hi Guys,

 

I am extracting data from json files with tFileInputJson component, it is not extracting UTF-8 Charcters by printing the output in tLogRow or tMySQLOutput. I have tried to change the encoding in advance settings but it didn't worked too.

Your help would be appriciated.

 

Thanks and Regards

Hitesh Mundra

Employee

Re: Convert non-UTF8 encoded files to UTF-8 encoded format

Hi Hitesh,

 

     Did you change the file encoding for the component to UTF-8 as shown below?

image.png

 

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 :-)

Five Stars

Re: Convert non-UTF8 encoded files to UTF-8 encoded format

Hi @nikhilthampi , I have already tried this but didn't worked.

Eleven Stars

Re: Convert non-UTF8 encoded files to UTF-8 encoded format

Did you already try tchangefileencoding?

Otherwise try routine attached in below link

https://community.talend.com/t5/Design-and-Development/tChangeFileEncoding-and-UTF8-encoding/m-p/149...

Otherwise Attach a sample file
Regards
Abhishek KUMAR
Five Stars

Re: Convert non-UTF8 encoded files to UTF-8 encoded format

Hi,

 

I have solved the issue by simply read file with tFileInputRaw and write tFileOutputRaw with UTF-8 Charcter set. This solved the issue.

 

Thanks and Regards

Hitesh Mundra

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now