topic Re: gui_upload in Application Development and Automation Discussions

gui_upload

Former Member — Wed, 22 Oct 2008 11:12:15 GMT

i have flat file like bellow

12358|FHDYDT2|122244002| | |00003

how can i up load to internal table ,

here delimeter is 'I' (pipe line )

which function module i have to use for it.

and specify which parameter i have to pass

Re: gui_upload

Former Member — Wed, 22 Oct 2008 11:17:30 GMT

Just search with the search term "GUI_UPLOAD", you will find lot of threads.

Re: gui_upload

Former Member — Wed, 22 Oct 2008 11:17:39 GMT

Hi,

You can use FM GUI_UPLOAD.

use Parameter - HAS_FIELD_SEPARATOR = 'X'

Re: gui_upload

Former Member — Wed, 22 Oct 2008 11:19:33 GMT

hi sujith

in my flat file delimeter is "I" pipe line .

Re: gui_upload

abdul_hakim — Wed, 22 Oct 2008 11:25:05 GMT

Jus read the data and later split it using SPLIT AT | Statement.

Cheers,

Hakim

Re: gui_upload

BH2408 — Wed, 22 Oct 2008 11:27:19 GMT

Hi ,

While upload , need to split and pass into the internal table.

Regards,

Bharani

Re: gui_upload

Former Member — Wed, 22 Oct 2008 11:40:37 GMT

how can i split and uplode to internal table

pls give one example

Re: gui_upload

Former Member — Wed, 22 Oct 2008 13:30:23 GMT

Hi,

Before posting its always better to search in SDN.

Lots and lots of threads on this issue.

Also split may be like this

SPLIT file AT '|' INTO <c1>... <cn> INTO TABLE <itab>

Check these.

[https://forums.sdn.sap.com/click.jspa?searchID=17789952&messageID=6013362]

[https://forums.sdn.sap.com/click.jspa?searchID=17789952&messageID=6273913]

If not solved please revert back. Will help you.

Rhea.

Edited by: rhea on Oct 22, 2008 3:33 PM

Re: gui_upload

Former Member — Thu, 23 Oct 2008 02:34:55 GMT

Hi Saimedha

You can first upload the file as 1 column table.

After you populated the data into that 1 column internal table,

you can loop the internal table, split the field at '|' into the designed column

of another internal table.

Your code might be like this:

"lt_string is internal table with 1 column. Column name let say zdata.
LOOP AT lt_string INTO lwa_string.
   SPLIIT lwa_string-zdata 
       AT '|'
      INTO gwa_data-field1
          gwa_data-field2
          gwa_data-field3
          gwa_data-field4
          gwa_data-field5
          gwa_data-field6
          gwa_data-field7
   APPEND gwa_data TO gt_data.
ENDLOOP.
"gt_data is your table with let say 7 field.

Have a nice try