topic Re: String being read wrongly in Talend Studio

String being read wrongly

Moe1 — Thu, 14 Mar 2019 11:45:32 GMT

I have a string field that has this text:

و ابنه Panama الاسم من دولة

However when I read it from the excel and insert it in the the DB it starts from the left to right:

الاسم من دولة Panama و ابنه

Is there a quick fix for such cases?

Re: String being read wrongly

akumar2301 — Thu, 14 Mar 2019 12:34:53 GMT

Can you please post sample record ?

Re: String being read wrongly

Anonymous — Thu, 14 Mar 2019 13:18:14 GMT

@Moe is that urdu or arabic language, according to your case, you can use tjavarow and perform operation according to your required output, and what is the language in that string

Re: String being read wrongly

Moe1 — Thu, 14 Mar 2019 13:50:14 GMT

@uganesh I did post a sample record in the first post.

@ksingh it is arabic, and I only need to copy from excel to DB without any transformation rules etc... Just copy/paste

Re: String being read wrongly

akumar2301 — Thu, 14 Mar 2019 13:55:11 GMT

Hello @Moe

It is weird that it is reversed , I needed the excel file sample which you are using.

It might be some setting in your excel.

Re: String being read wrongly

Moe1 — Thu, 14 Mar 2019 14:16:46 GMT

@uganesh I see, I did the excel settings as required (The Paragraph setting from right to left) and the text alignment too.

Re: String being read wrongly

Anonymous — Fri, 15 Mar 2019 14:40:35 GMT

@Moe

Are you still having the this issue?

If yes, could you please print the data and see the output at each areas before loading to DB?

I would also request to save the input excel in csv format to remove any of the auto formatting functionalities of Excel. After saving it in csv, open using a plain text editot like Notepad++ and check whether the data is in reverse order at input stage itself.

Please also use UTF-8 for all the components in your job.

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 🙂