How to retain special characters and foreign languages /Chinese characters

[arnab_mondal2]

Hi All , I have a .xls file that needs to be picked from an SFTP , and then converted to a Json so that I can post it to an API . Issue is all this while it was carrying English language in one of the columns and going fwd it will have all different languages like Chinese and Thai . the moment it is sending files in these languages , its failing. can someone tell me how this can be handled ? sample file shown below .

PS- I have already gone through : https://blogs.sap.com/2017/10/31/sap-cloud-platform-integration-hana-cloud-integration-hci-creating-...

just in case.

[Sriprasadsbhat]

Hello Arnab,

Could you please set encoding encoding to ISO-8859-1 or UTF-8 ( explicitly set using content modifier ) which would retain above characters.

Below KBA will guide you about how to set encoding using content modifier.

https://launchpad.support.sap.com/#/notes/0002533303

Regards,

Sriprasad Shivaram Bhat

[gregorw]

Maybe you're better use .xlsx as they use XML internally and that is UTF-8 encoded.

[arnab_mondal2]

Unable to load excel file . Not sure how .xlsx conversion with support foreign language either , let me see how I can send the file.Tried converting to .txt , but sdn not allowing to load.

[arnab_mondal2]

are you saying .xlsx will handle the language issue ?

[Sriprasadsbhat]

Hello Arnab,

It would be great if you could attach sample data which are trying to transform( you can mask customer related fields ).

Regards,

Sriprasad Shivaram Bhat

[arnab_mondal2]

https://drive.google.com/file/d/1xgbHEuw71kWZK_mOnVHPhX9kt0qxsqN9/view?usp=sharing

[arnab_mondal2]

@shiv pls check if you can access the file

[arnab_mondal2]

@sriprasadshivaramabhat

could you pls comment ?