format internal table

[Former Member]

All experts:

helo, I want to add '|' character to internal table, and download it in to local file, how to do that.

like this,

A column B column C column

test test test

test test test

now add '|' and download to local file,

A column B column C column

'|' test '|' test '|' test '|'

'|' test '|' test '|' test '|'

how to write code in ABAP program?

Thanks in advance

[Former Member]

Hi,

First concatenate...

loop <table>
CONCATENATE 'I' <table-field> INTO <table-field> separated by space.
CONCATENATE 'I' <table-field1> INTO <table-field1> separated by space.
CONCATENATE 'I' <table-field2> INTO <table-field2> separated by space.
modify <table>
endloop.

now use fm WS_EXCEL to download it to excel or fm gui_download

[Former Member]

Hi Kevin,

You can find a sample code at this link for your requirement.

[http://www.sap-img.com/abap/insert-a-special-tab-delimited-character.htm]

Regards,

Amit.