To Avoid Unwanted characters

[Former Member]

hi everybody,

i am updating a record which is 5000 characters into a 'Y' Datbase table in a field which

can accomodate this 5000 characters in a single line from text editor.

The data is being inputed in Text editor which can carry not more than 5000 characters and if i press

save then the text which is written on the editor will be saved in the database table.

But the problem is i am some unwanted characters of format '#####" are getting stored in the table

which will dynamically incrase its size and position.

for e,g : 'Terms and Conditons Text#### for Material and Services#######.Services Terms can liable

to CENVAT################.Please follow the below steps' .

The above example shown will be stored ine the database despite i have not entered #####

characters.

I want to Print this text in SAP SCRIPT.

I want to print the text which i have entered in Text Editor as it should be.

Note: The Text Editor is designed using Class CL_GUI_TEXTEDIT with methods

SET_TEXT_AS_R3TABLE

GET_TEXT_AS_STREAM.

[Former Member]

hi everybody,

i am updating a record which is 5000 characters into a 'Y' Datbase table in a field which

can accomodate this 5000 characters in a single line from text editor.

The data is being inputed in Text editor which can carry not more than 5000 characters and if i press

save then the text which is written on the editor will be saved in the database table.

But the problem is i am some unwanted characters of format '#####" are getting stored in the table

which will dynamically incrase its size and position.

for e,g : 'Terms and Conditons Text#### for Material and Services#######.Services Terms can liable

to CENVAT################.Please follow the below steps' .

The above example shown will be stored ine the database despite i have not entered #####

characters.

I want to Print this text in SAP SCRIPT.

I want to print the text which i have entered in Text Editor as it should be.

Note: The Text Editor is designed using Class CL_GUI_TEXTEDIT with methods

SET_TEXT_AS_R3TABLE

GET_TEXT_AS_STREAM.

[Former Member]

Hi,

maybe your problem can be because unicode problem, with special characters. Check the characters that is in ####.

[rainer_hbenthal]

TABs? CRs? LFs? Write a small program reading the table and have a look in the debugger for the real hexadecimal notations. For sure the hash sign is only displayed for non displayable characters.

[Former Member]

HI,

Check this Demo program SAPSCRIPT_DEMO_NOTE_EDITOR

[Former Member]

Hi Murali,

The data are stored along with line feed details,thats why you get ## symbols.

use

GET_TEXT_AS_R3TABLE - This allows you to save the editor content without line feeds .

Check this below link

http://help.sap.com/saphelp_45b/helpdata/en/ed/b6f9d3ee1511d1952000a0c930660b/frameset.htm

Hope it helps.

[Former Member]

hi thanks to all