code

[Former Member]

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

[Former Member]

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

[Former Member]

Look at the help for the command REPLACE

[Former Member]

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

[Former Member]

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

[Former Member]

hi

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^