comma seperated file

[Former Member]

Hi,

Just want an idea to download comma seperated file.

thanks and best regards.

Kusum.

[GauthamV]

hi,

in gui_download function module use this.

WRITE_FIELD_SEPARATOR = ' '

[Former Member]

after you download the data

we can use like this

loop at IT_itab1 into itab1.

 split itab1-field at ',' into wa_bill-BILLNO wa_bill-BDATE WA_BILL-BYEAR WA_BILL-BMONTH
          WA_BILL-OFFAREA WA_BILL-SOURCESYSTEM WA_BILL-MATDESC WA_BILL-ADVERTISCOST WA_BILL-COMM
          WA_BILL-GROSSAMOUN WA_BILL-CASHDISCOUNT WA_BILL-NETAMOUNT WA_BILL-CUSTCODE WA_BILL-CUSTNAME
          WA_BILL-PROCODE WA_BILL-PROJID WA_BILL-WBSELE.

APPEND WA_BILL to IT_BILL.

endloop.

[Former Member]

Hi Kusum,

As also told by others, if you are using FM GUI_DOWNLOAD than you have to give WRITE_FIELD_SEPARATOR as 'X' for separator and space if you dont want separator and by default it is always space.

With luck,

Pritam.

[Former Member]

Hi,

use open dataset to download from AS to IT

& IT to AS.

Thanks,

Krishna