Problem using SPLIT

Former Member — Wed, 27 Jan 2010 18:31:25 GMT

Hi friends, i need help with this simple problem. I made and upload of TXT file separated by tab and now I'm trying to split the fields into an internal table, but does't work:

First, table after upload:

BRBR#BRBA#AE-EQPC-02#99999#8085#1#29/11/2012

My program:

CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      filename                = p_path
      filetype                = 'ASC'
      read_by_line            = 'X'
    TABLES
      data_tab                = it_upload
    EXCEPTIONS
      file_open_error         = 1
      file_read_error         = 2
      no_batch                = 3
      gui_refuse_filetransfer = 4
      invalid_type            = 5
      no_authority            = 6
      unknown_error           = 7
      bad_data_format         = 8
      header_not_allowed      = 9
      separator_not_allowed   = 10
      header_too_long         = 11
      unknown_dp_error        = 12
      access_denied           = 13
      dp_out_of_memory        = 14
      disk_full               = 15
      dp_timeout              = 16
      OTHERS                  = 17.

  IF sy-subrc = 0.
    loop at it_upload into wa_upload.
      at FIRST.
        continue.
      endat.

      split wa_upload at '#' into  wa_datatab-werks
                                   wa_datatab-lgort
                                   wa_datatab-matnr
                                   wa_datatab-lote_o
                                   wa_datatab-lote_d
                                   wa_datatab-qtde
                                   wa_datatab-valid.
      APPEND wa_datatab to it_datatab.
    endloop.

  ENDIF.

In result of split, only first field is transported to wa_datatab-werks and others fields area blank.

Thanks for any help!

Re: Problem using SPLIT

former_member156446 — Wed, 27 Jan 2010 18:40:55 GMT

data: lv_tab type ABAP_CHAR1 value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

split wa_upload at lv_tab  into  wa_datatab-werks
                                   wa_datatab-lgort
                                   wa_datatab-matnr
                                   wa_datatab-lote_o
                                   wa_datatab-lote_d
                                   wa_datatab-qtde
                                   wa_datatab-valid.
      APPEND wa_datatab to it_datatab.

Re: Problem using SPLIT

Former Member — Wed, 27 Jan 2010 18:48:57 GMT

Thanks J@y. I didn't know about this char for tab.

topic Re: Problem using SPLIT in Application Development and Automation Discussions

Problem using SPLIT

Re: Problem using SPLIT

Re: Problem using SPLIT