Skip to Content
0
Former Member
Sep 20, 2007 at 06:42 AM

Help please!!!

17 Views

Experts help me please...

How can I avoid these scenario::

Everytime I download a file in excel. after '#' character the next text to its right side proceeds to next line.

example:

blue #eyes

excel output:

row 1 blue #

row2 eyes

I need to displayed that text in just one cell.

Gosh!!Ive tried lots of different ways but all of them failed..

my code::

LOOP AT gt_eban INTO wa_eban.

SEARCH wa_eban-txz01 FOR cl_abap_char_utilities=>horizontal_tab.

IF sy-subrc = 0.

REPLACE ALL OCCURRENCES OF cl_abap_char_utilities=>horizontal_tab

IN wa_eban-txz01 WITH ' '.

MOVE wa_eban-txz01 TO wa_output-txz01.

ELSE.

MOVE wa_eban-txz01 TO wa_output-txz01.

ENDIF.

endloop.

Help..