Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem using SPLIT

Former Member
0 Likes
363

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!

1 ACCEPTED SOLUTION
Read only

former_member156446
Active Contributor
0 Likes
336
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.
2 REPLIES 2
Read only

former_member156446
Active Contributor
0 Likes
337
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.
Read only

Former Member
0 Likes
336

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