Need Inputs on how to download data into excel from an internal table

[ABAPer_1631]

Hello,

Need inputs on below requirement:

I would like to move data into excel of an internal table which has a field that stores long text with multiple lines separated by '#' (cl_abap_char_utilities=>newline). I would like to replace "#' with some character so that it will add that entry in a new line in the downloaded excel.

Please find the below use case:

say, I have data in internal table it_tab1 with work area ls_tab1.

Now, this lstab1-<field> = string1 #string2 #string3

Now, I want input of the field in the downloaded excel as below:

string1

string2

string3

Please provide possible solutions.

Note: I have used below statement still not able to get data as expected.

REPLACE ALL OCCURRENCES OF '#' IN lstab1-<field> WITH cl_abap_char_utilities=>newline.

and I am using SCMS_STRING_TO_XSTRING FM to convert string to xstring.

Thanks in Advance!

[ulrich_mhrke]

Vielleicht hilft es, den Feldwert in der Ausgabe durch " einzuschließen. In etwa:

<field> = `"` && <field> && `"`