Skip to Content
0
Former Member
Dec 03, 2006 at 01:03 PM

Problem with '#'

36 Views

Hello Experts,

I have issue with '#'. The problem is when I use tab delimited file for upload, system uses '#' as the seperator. System doesn't split at '#' when I use

( split xflat at '#' into table irec ) statement.

start-of-selection.

  • Add X number of fields to the dynamic itab cataelog

do p_flds times.

clear wa_it_fldcat.

wa_it_fldcat-fieldname = sy-index.

wa_it_fldcat-datatype = 'C'.

wa_it_fldcat-inttype = 'C'.

wa_it_fldcat-intlen = 10.

append wa_it_fldcat to it_fldcat .

enddo.

.

  • Create dynamic internal table and assign to FS

call method cl_alv_table_create=>create_dynamic_table

exporting

it_fieldcatalog = it_fldcat

importing

ep_table = new_table.

assign new_table->* to <dyn_table>.

  • Create dynamic work area and assign to FS

create data new_line like line of <dyn_table>.

assign new_line->* to <dyn_wa>.

file = p_file.

call method cl_gui_frontend_services=>gui_upload

exporting

filename = file

changing

data_tab = iflat

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.

loop at iflat into xflat.

clear irec. refresh irec.

split xflat at '#' into table irec.

loop at irec.

tabix = sy-tabix.

assign component tabix of structure <dyn_wa> to <dyn_field>.

<dyn_field> = irec.

endloop.

append <dyn_wa> to <dyn_table>.

endloop.

Please help me out. It is very urgent and I have already spent lot of time to solve this issue which couldn't.

Many Thanks.