Help:Transfer routine to convert to upper case,replace #,! with space

[Former Member]

Hello,

Can anyone please tell me the transfer routine code for converting into upper case and also replacing # and ! with space.

The following code I have in my mind:

To convert to upper case:

TRANSLATE TRAN_STRUCTURE-<<field name>> to UPPER CASE.

RESULT = TRAN_STRUCTURE-<<field name>>

To replace # and ! with space:

REPLACE # ! WITH " ".

I need the routine both to convert into upper case and as well replace # and ! with Space.

Can anyone please help me.

Thanks,

Praveen

[Former Member]

Hello Everyone,

Thanks to all for the support. The problem got resolved.

Thanks,

Praveen Tati

[Former Member]

Hi,

If the problem is solved you can close the thread and reward answers that helped you.

Best regards,

Eugene

[Former Member]

Hi Praveen,

Here:

you can find several pieces of code for solving your problems.

Best regards,

Eugene

[Former Member]

Eugene,

I realize that this post is very out-dated. However, I'm interested in the link that you provided Praveen (it is no longer available). I believe I'm having the same issue. Please note my post from 09/19/06:

"Forbidden Characters "

Posted: Sep 19, 2006 5:05 PM Reply E-mail this post

I am attempting to load text from R/3 into an infoobject, and then into an infocube. The text from R/3 has forbidden characters (i.e. # and tabs). I have tried adding the forbidden characters in RSKC, and I have tried entering ALL_CAPITAL in RSKC. I have also tried flagging the infoobject for lowercase letters. None of the above have been successful.

From the research I've done, it seems the only solution is to write ABAP code in the update rules going into the infocube. However, our system is a unicode system. Any type of code examples that I've found have been for non-unicode systems.

My question is, what is the best solution for a unicode system? Also, changing the source data in R/3 is not an option. Thank you in advance for any suggestions.

[Former Member]

Hello,

Thankyou Kamaljeet and Praveen for the response.

Kamaljeet - I want to replace the entries(#,!) for the <<field name>> with "space".

Now I have other problem, I encountered with a special charater " ' "

Is there any functional module which will allow all the entries like "#" , "!" , " ' " etc.

Please help me.

Thanks,

Praveen Kumar Tati

[Former Member]

Hi

You have to add it twice.

(4times including the first and the last one).

WHILE output CA ''''.

REPLACE '''' WITH ' ' INTO output.

ENDWHILE.

Kind regards

Reinhard

Message was edited by: Reinhard Bär

[Private_Member_9643]

Hello praveen,

for transfering the field value to upper case is ok,

but i am confused that you want to replace # with " " for which value?, for the value in the field_name or anything else?

Regards,

Kamaljeet

Message was edited by: Kamaljeet Singh

[Former Member]

Hi,

Please have a look into note 173241.

The problem in your case is the single character # which is not

permitted in BW.

The only way to upload data is a conversion in the transfer rules,

1. -> EUR.

Regards,

GPK.