topic Re: GUI_OPLOAD inserting empty rows in Application Development and Automation Discussions

GUI_OPLOAD inserting empty rows

TimVDB92 — Tue, 14 Jul 2015 10:17:50 GMT

I'm using the FM 'GUI_UPLOAD' to read a .TXT file into an internal table in my code, the file is tab delimitted.

The function is working, but when my txt-file is ending with 50 empty rows,

the function is adding these rows to my Internal table in a '#' format.

Is it possible to delete these?

Code:

call function 'GUI_UPLOAD'

exporting

filename = p_path

filetype = 'ASC'

dat_mode = ''

tables

data_tab = it_datatab

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.

Re: GUI_OPLOAD inserting empty rows

hitesh_gabani — Tue, 14 Jul 2015 10:45:37 GMT

Hi,

Loop at it_datatab into some work area(wa_datatab)

then use the follwing split statement.

SPLIT wa_datatab AT

cl_abap_char_utilities=>horizontal_tab INTO workarea-fields

and check if WA_MAT is not initial

than append to another internal table before ending loop.

Regards,

Hitesh

Re: GUI_OPLOAD inserting empty rows

Former Member — Tue, 14 Jul 2015 11:13:37 GMT

DELETE FROM it_datatab WHERE table_line = space.

Should work too to remove ALL blank lines.

Re: GUI_OPLOAD inserting empty rows

SwadhinGhatuary — Tue, 14 Jul 2015 11:23:46 GMT

Hi,

If possible attach the tab delimited file with code for inspection.

try not to put any blank space line other wise make a loop at internal table

read first char of first field which will # then delete that row from internal table .