topic Re: uploading text file in Application Development and Automation Discussions

uploading text file

Former Member — Mon, 25 Sep 2006 06:51:08 GMT

I have a text file with at least 5 column.

Using upload fm and transfer to internal table.

However, is there a faster way to upload whereby the columns from the text file will flow into the respective itab column directly?

Re: uploading text file

Former Member — Mon, 25 Sep 2006 07:00:56 GMT

hi,

we first read the text file into an internal table itab1 and then we fill itab2 in the order of columns.

using FM get text into itab1.

loop at itab1.

itab2-var1 = itab1+0(4).

and so on...

append itab2.

endloop.

reward if useful...

Re: uploading text file

Former Member — Mon, 25 Sep 2006 07:07:22 GMT

Declare ur internal table with 5 fields and use GUI_UPLOAD FM

data : begin of itab occurs 0,
         col1(15),
         col2(15),
         col3(15),
         col4(15),
         col5(15),
       end of itab.

CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      filename                      = 'C:Text.txt'
   FILETYPE                      = 'DAT'
*     has_field_separator           = 'X'
*   HEADER_LENGTH                 = 0
*   READ_BY_LINE                  = 'X'
*   DAT_MODE                      = ' '
*   CODEPAGE                      = ' '
*   IGNORE_CERR                   = ABAP_TRUE
*   REPLACEMENT                   = '#'
*   CHECK_BOM                     = ' '
* IMPORTING
*   FILELENGTH                    =
*   HEADER                        =
    TABLES
      data_tab                      = itab

Re: uploading text file

Former Member — Mon, 25 Sep 2006 07:08:42 GMT

the itabfields should be of the same order as in text file.

so that it ill be faster.

also use GUI_Upload

Re: uploading text file

Former Member — Mon, 25 Sep 2006 07:10:40 GMT

u can used GUI_Upload function module

Re: uploading text file

Former Member — Mon, 25 Sep 2006 07:11:18 GMT

if your text file is having any field seperator like TAB seperated or comma seperated,then you can use GUI_UPLOAD function module and put

HAS_FIELD_SEPERATOR = 'X' this parameter in GUI_UPLOAD,then automatically values will be populated to your Internal table.

Regards,

Srikanth