SAP Directory Data Download Issue

[former_member207873]

Hi Experts,

I am downloading a file from AL11 into notepad or excel.

In AL11, data looks like this.

But when we try to download into excel or word the data is getting changed,

In Excel

Further a digit 5 is getting appened in the beginning.

In notepad

What can be done so that the data will be exactly as it is in AL11.

B.R.

[former_member207873]

any help ?

[nils_buerckel]

Hi,

Please have a look at SAP note 1991903 - in a Unicode system (I assume you use a Unicode system) AL11 stores files based on UTF-8.

Now you could add a UTF-8-BOM (Byte Order Mark - 0xEFBBBF) at the beginning of  the file - then new Excel versions should be able to display the content correctly.

See e.g.  Byte order mark - Wikipedia, the free encyclopedia

Best regards,

Nils Buerckel

[former_member207873]

Done with HTML coding.