on 03-05-2009 12:01 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.