topic Re: cg3z t-code in Application Development and Automation Discussions

cg3z t-code

Former Member — Fri, 29 Aug 2008 12:47:30 GMT

hi SDNers,

During upload a file from presentation server to application server using cg3z, it is successfully uploaded with # symbol inbetween the datas.

I dont want # symbol in between the datas.how to do that?

FYI,

I am uploading excel file or tab delimited formatted text file without title.

I am using that datas for one std program.

plz help.

Re: cg3z t-code

Former Member — Fri, 29 Aug 2008 12:49:27 GMT

Hi,

When TAB delimited file is uploaded into application server, # will be coming as the separator b/w the values in place of TAB space.

With Regards,

Dwarakanath.S

Re: cg3z t-code

Former Member — Fri, 29 Aug 2008 12:50:06 GMT

Those '#' are nothing But Tabs.

They are equivalent to Tabs.

if you don't want them to see you have to upload a plain text file.

Programatically you can replace them when you are reading if you wnat..

Using CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB you can replace them inside a program.

Re: cg3z t-code

Former Member — Fri, 29 Aug 2008 12:50:30 GMT

And this cannot be avoided

Re: cg3z t-code

Former Member — Fri, 29 Aug 2008 13:32:05 GMT

Hi,

'#' is an internal representation of the tab.

As Vijay said,

Programatically you can replace them when you are reading if you want.

Check this sample code, here i uploaded thetab delimited formatted text file and removed the # by using cl_abap_char_utilities=>horizontal_tab.

CONSTANTS:
  con_tab TYPE c VALUE cl_abap_char_utilities=>horizontal_tab.

DATA:
  BEGIN OF itab OCCURS 0,
        data(100),
  END OF itab.

DATA:
  BEGIN OF itab1 OCCURS 0,
    vbeln  LIKE vbap-vbeln,
    posnr  LIKE vbap-posnr,
  END OF itab1.

CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
   filename = 'C:\temp\text2.txt'
  TABLES
   data_tab = itab.

LOOP AT itab.
  SPLIT itab-data AT con_tab INTO itab1-vbeln itab1-posnr.
  APPEND itab1.
ENDLOOP.

Regards

Adil

Re: cg3z t-code

Former Member — Tue, 25 Nov 2008 03:29:48 GMT

Hi Senthil,

I just happened to see your thread....

The Solution to remove the #s is this....

1. Save your excel file in .csv (Comma seperated) format.

2. Open the saved .csv file in a Notepad.

3. Now, replace the comma with nothing.

4. Save the file.

5. Your problem is Solved.

Check this solution.

Thanks & Regards,

Kumarpal Jain.