Skip to Content
0

Japanese name format issue in csv

Oct 12, 2017 at 02:31 PM

41

avatar image
Former Member

Hi ,

We have a zip file encloses CSV (to be mailed to users), which has japanese name messed up. We tried -o shift-jis, and it is not working out.

It works on scenario:

* unzip the csv file and open in notepad and just click save, den opens the csv, japanese names comes correctly.

But since it is to be emailed, saving every time is not possible for users. Kindly advise

SAP CRM Sales
CRM Business Partner | ABAP Development
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Sandra Rossi Answered Nov 16, 2017 at 07:51 AM
0

If you open the CSV file with Microsoft Excel, it has "always" worked correctly if the file was encoded with UTF-16LE, with a leading BOM, as shown in these tests: https://wiki.scn.sap.com/wiki/display/ABAP/CSV+tests+of+encoding+and+column+separator

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users