topic Re: code in Application Development and Automation Discussions

code

Former Member — Wed, 08 Nov 2006 10:54:03 GMT

Hi experts,

see the below code.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>CLIPBOARD_IMPORT

IMPORTING

DATA = EXCEL_TAB1

EXCEPTIONS

CNTL_ERROR = 1

OTHERS = 4.

IF SY-SUBRC <> 0.

MESSAGE A037(ALSMEX).

ENDIF.

The EXCEL_TAB1 contains only one field of 4096 characters.

When i see the contents of EXCEL_TAB1 in debugging ,

it containd # in between....

How can we remove those #....?

Regards

Re: code

Former Member — Wed, 08 Nov 2006 10:56:09 GMT

This is the following post to my previous..

Suppose the EXCEL_TAB1 contains '#'...how can we remove it..can we do it by searching that #...?..how can we do it?

Regards

Re: code

Former Member — Wed, 08 Nov 2006 11:00:32 GMT

Look at the help for the command REPLACE

Re: code

Former Member — Wed, 08 Nov 2006 11:05:10 GMT

Usually, ABAP uses the character '#' to represent (unicode) characters, that cannot be displayed, i. e. asian characters ...

Re: code

Former Member — Wed, 08 Nov 2006 11:06:40 GMT

hi,

do like this

<b>translate EXCEL_TAB1 using '# '.

condense s no-gaps.</b>

suppose take this

data:s(10) type c value 'ab#c'.

translate s using '# '. (don't forget to give 1 space after '#' inside single quotes)

condense s no-gaps.

write:/ s.

o/p will be abc.

Reward points if it helps you

Regards,

Sowjanya

Message was edited by: sowjanya s

Re: code

Former Member — Wed, 08 Nov 2006 11:12:24 GMT

good

check with your there might be some length prob that is the reason it is entering one junk character in that, check out the field value in the data base, wheather it contain any # or not, if not than there must be some hidden value it is getting while debugging the process.

thanks

mrutyun^