Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Junk data is coming in my downloaded Excel

former_member194142
Participant
0 Kudos
537

Hello,

I'm trying to download SAP data into excel in OS by using OPEN DATASET ENCODING UTF-8, most of the data is ok, but getting junk for Trade Mark symbol (TM symbol as super-script/sub-script), as below

Tarde Mark 1™ symbol

Pl. let us know how get this TM symbol from SAP to Excel

Thank you

1 ACCEPTED SOLUTION

Sandra_Rossi
Active Contributor
131

When you say Excel format, it's in fact CSV in your case.

Excel only opens correctly a CSV file without special action by storing the text under UTF-16LE (SAP code page 4103) with a BOM, and fields separated with a horizontal tabulation character.

Otherwise, the user may need to open the file using Excel menu Data -> Open from text -> Import, then choose the code page "65001 Unicode UTF-8".

Workaround: use the XLSX format instead of CSV (search for abap2xlsx)

5 REPLIES 5

former_member194142
Participant
0 Kudos
131

Any help pl.?

kiran_k8
Active Contributor
0 Kudos
131

Hi,

Google for info on how to create macros in excel from ABAP.

And then accordingly you can check how to create a superscript macro in excel from ABAP

K.Kiran.

Sandra_Rossi
Active Contributor
132

When you say Excel format, it's in fact CSV in your case.

Excel only opens correctly a CSV file without special action by storing the text under UTF-16LE (SAP code page 4103) with a BOM, and fields separated with a horizontal tabulation character.

Otherwise, the user may need to open the file using Excel menu Data -> Open from text -> Import, then choose the code page "65001 Unicode UTF-8".

Workaround: use the XLSX format instead of CSV (search for abap2xlsx)

0 Kudos
131

Thank you Sandra, we are saving data in .XLS format, user will specify a file name themselves on the selection screen of the report, but we educated the user to specify only .XLS format, example, my_download_file.XLS

Any ideas pl. how to get Trade mark symbol on my_download_file.XLS?

thank you

131

Mentioning XLS as an extension does not make the XLS format. If it was the true XLS format (binary format also called BIFF, which existed before Excel 2007 XLSX), you wouldn't have issues with character encoding. So, users choose XLS extension name, and it's CSV format (or CSV-like format), which is a text format, and thus may lead to issues with character encoding.

The answers are in my previous reply (choose one among the 3 possible solutions, respectively proposed in paragraphs 2, 3 and 4).