Skip to Content
avatar image
Former Member

Japanese name format issue in csv

Oct 12, 2017 at 02:31 PM | 45 Views | Last edit Nov 15, 2017 at 10:21 PM 3 rev.

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Sandra Rossi
    Nov 16, 2017 at 07:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded