Help please!!!

[Former Member]

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..

[naimkhans_babi]

Dear Salma..

How are you! well could you send me the whole code if possible i want to debug this. I feel here '#' is considered as tabdiliminator,

my mail address is nbabi@yahoo.com

regards

naeem

[Former Member]

Thank you so much for your effort to check my code..

I already send you my codes...its through gmail..Please help me..

Ill wait for your feedback..tnx..

[Former Member]

Experts!!!

Any feedback on my problem???

[naimkhans_babi]

Hi!

use this one.

Search wa_eban-txz01 For '#'.

if sy-subrc = 0.

REPLACE ALL OCCURRENCES OF '#' IN wa_eban-txz01 with ' '.

MOVE wa_eban-txz01 TO wa_output-txz01.

ELSE.

MOVE wa_eban-txz01 TO wa_output-txz01.

ENDIF.

MOVE-CORRESPONDING wa_eban TO wa_output.

• SEARCH wa_eban-txz01 FOR cl_abap_char_utilities=>horizontal_tab. <-- it look for the #

• IF sy-subrc = 0. <--- value is getting changed with 4.

• REPLACE ALL OCCURRENCES OF cl_abap_char_utilities=>horizontal_tab

• IN wa_eban-txz01 WITH ' '. <---- this is not executing.

• MOVE wa_eban-txz01 TO wa_output-txz01.

• ELSE.

• MOVE wa_eban-txz01 TO wa_output-txz01.

• ENDIF.

*

• MOVE-CORRESPONDING wa_eban TO wa_output.