cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding Line Space Problem when we insert the text into R3 table

Former Member
0 Kudos

Dear All

When i insert the long text like below

Start --> This is a sample test justification so inserting the justification row by row thats why we have to handle the things carefully.This is a

sample test jsutification so inserting the justification row by row thats why we have to handle the things carefully. <---End

from pop up window into the R3 table i am facing problem in the above scenario.

When i check in the R3 table it shows "This is a sample test jsutification so inserting the jsutification row by row thats why we have to hadle the things carefully.This is a #### sample test jsutification so inserting the jsutification row by row thats why we have to hadle the things carefully"

Problem is whenever i send the text along with line space it automatically takes #### symbol into the R3 table.

how to remove the #### symbol when inserting the R3 table

Note : I have tried replace and trim and remove function.it wont work

how to avoid this problem.

regards

Dhinakaran

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Dhinakaran,

We have had the same problem. Whenver the R3 table reads some data from the portal or something, if it finds a SPACE which has formed because of pressing TAB key on your keyboard, it reads it as a special character and puts a "#" symbol in that place. Try to avoid pressing the TAB key for a space and use the SPACE BAR key. Or else you have to write some code on to the input field by restricitng the end user without entering a space with TAB key.

I hope this helps. Let me know if you have any issue.

All the best,

PG.

Former Member
0 Kudos

Hi

So for i did not get any answer for the above question,

How to remove the /n and /r when we inserting and retreving the long text from R3 table

Kindly let me know the answer

we have more no of users here. So we cant tell to avoid the tab key.

Is there any technical soultion or any logic to remove the # when we insert the long text into R3 table

and also retrieve the value from R3 table

Regards

Dhinakaran

Edited by: Karthikeyan Ramasamy on Mar 7, 2009 12:27 PM

Edited by: Karthikeyan Ramasamy on Mar 10, 2009 11:40 AM

Former Member
0 Kudos

Hi Dhinakaran,

As far as I know, when we had problems our ABAP guy wrote some code in a Functional Module to replace some special characters like "TAB SPACE". I am not exactly sure about the code as I am not an ABAPer. I would suggest you to speak to your ABAPer about this issue.

Regards,

Gopal.

Former Member
0 Kudos

Hi Dhinakaran,

I just spoke to our ABAPer and got the code for you. But, I am not sure if it makes any sense to you. Just trying to give you some idea about the way we approached to resolve the issue. I hope this helps you.


FUNCTION Z_REMOVE_INVALID_CHARS.

*"----------------------------------------------------------------------

*"*"Local Interface:

*" IMPORTING

*" REFERENCE(IMPORTCHAR) TYPE STRING

*" EXPORTING

*" REFERENCE(EXPORTCHAR) TYPE STRING

*"----------------------------------------------------------------------

DATA: L_USER_ALLOWED_CHAR TYPE RSALLOWEDCHAR,

input(200) type c,

L_ALL_ALLOWED_CHAR(140) TYPE C,

L_RESULT_STR_LEN TYPE I,

L_STR_INCREMENT TYPE I.

CONSTANTS C_SAP_ALLOWED_CHAR(58) TYPE C VALUE

' !"%&''()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'.

IF L_ALL_ALLOWED_CHAR IS INITIAL.

SELECT SINGLE * FROM RSALLOWEDCHAR

INTO L_USER_ALLOWED_CHAR

WHERE ALLOWKEY = 'S'.

CONCATENATE C_SAP_ALLOWED_CHAR

L_USER_ALLOWED_CHAR-ALLOWCHAR

INTO L_ALL_ALLOWED_CHAR.

ENDIF.

input = importchar.

TRANSLATE input TO UPPER CASE.

L_RESULT_STR_LEN = STRLEN( input ).

L_STR_INCREMENT = 0.

WHILE L_STR_INCREMENT LE L_RESULT_STR_LEN.

IF NOT input+L_STR_INCREMENT(1) CO L_ALL_ALLOWED_CHAR.

input+L_STR_INCREMENT(1) = ' '.

ENDIF.

ADD 1 TO L_STR_INCREMENT.

ENDWHILE.

exportchar = input.

 

ENDFUNCTION.


Regards,

Gopal.

Answers (0)