Adding newline and tab characters to a string

[Former Member]

Hi,

I have a silly problem. I am reading data from an internal table and would like to put it in a CSV file for download. I am reading the data into a string object. I need to delimit the string by the column delimiter (tab character) and the rows by the row delimiter (new line character). What characters do i use for these?

Thanks in advance for your help.

Shailesh

PS:- I am not able to use the hexadecimal separator since when i loop through the table and assign columns to my field symbol, it expects the assignation to be made to a string and not xstring.

Message was edited by: Shailesh Unny

[Former Member]

Hi,

I have a silly problem. I am reading data from an internal table and would like to put it in a CSV file for download. I am reading the data into a string object. I need to delimit the string by the column delimiter (tab character) and the rows by the row delimiter (new line character). What characters do i use for these?

Thanks in advance for your help.

Shailesh

PS:- I am not able to use the hexadecimal separator since when i loop through the table and assign columns to my field symbol, it expects the assignation to be made to a string and not xstring.

Message was edited by: Shailesh Unny

[RichHeilman]

You can use some attributes from the class cl_abap_char_utilities.

cl_abap_char_utilities=>horizontal_tab 
cl_abap_char_utilities=>CR_LF

Regards,

Rich Heilman

[Former Member]

Thanks Rich. It worked perfectly. One more question. I have a column which will have a lot of text including newline characters. Is there any way to ensure that after download this stays in the same column (in excel) ?

[RichHeilman]

The newline character within the field may cause you are a problem. Have you tested this yet? You may have to remove these characters before downloading.

Regards,

Rich Heilman

[Former Member]

Yes. In one column of the Table there is a lrge string with new line characters. I would like to download this entire string into a single column in excel. I can remove/translate the newline characters in this column. My question was is there any way to replace them when the download is being prepared?

Thanks again for your help.

[RichHeilman]

You will need to handle the remove/translating of the newline characters directly in your internal table, before you download.

Regards,

Rich Heilman

[Former Member]

Thanks a lot Rich. You have been very helpful.