topic Re: comma seperated file in Application Development and Automation Discussions

comma seperated file

Former Member — Fri, 17 Oct 2008 07:33:54 GMT

Hi,

Just want an idea to download comma seperated file.

thanks and best regards.

Kusum.

Re: comma seperated file

GauthamV — Fri, 17 Oct 2008 07:36:13 GMT

hi,

in gui_download function module use this.

WRITE_FIELD_SEPARATOR = ' '

Re: comma seperated file

Former Member — Fri, 17 Oct 2008 07:39:48 GMT

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.

Re: comma seperated file

Former Member — Fri, 17 Oct 2008 07:45:16 GMT

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.

Re: comma seperated file

Former Member — Fri, 17 Oct 2008 08:38:01 GMT

Hi,

use open dataset to download from AS to IT

& IT to AS.

Thanks,

Krishna