String being read wrongly

[Moe1]

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?

[akumar2301]

Can you please post sample record ?

[Anonymous]

@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

[Moe1]

@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

[akumar2301]

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.

[Moe1]

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

[Anonymous]

@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 🙂