topic Re: Help please!!! in Application Development and Automation Discussions

Help please!!!

Former Member — Thu, 20 Sep 2007 06:42:26 GMT

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

Re: Help please!!!

naimkhans_babi — Thu, 20 Sep 2007 06:57:01 GMT

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

Re: Help please!!!

Former Member — Thu, 20 Sep 2007 07:09:56 GMT

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

Re: Help please!!!

Former Member — Thu, 20 Sep 2007 07:54:23 GMT

Experts!!!

Any feedback on my problem???

Re: Help please!!!

naimkhans_babi — Thu, 20 Sep 2007 08:16:28 GMT

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.