topic Re: How to Replace ',' with '.' in workarea in Application Development and Automation Discussions

How to Replace ',' with '.' in workarea

Former Member — Tue, 27 May 2008 14:51:40 GMT

Hi ,

I am getting amount field from workarea wa_amount

wa_amount = 27.777,00

But I want to display output like 27,777.00 ( replace , with . & . with ,)

Please let me know the best possible way to do this

Regards

rahul

Re: How to Replace ',' with '.' in workarea

Former Member — Tue, 27 May 2008 14:56:06 GMT

U have to do in User setings

Re: How to Replace ',' with '.' in workarea

Former Member — Tue, 27 May 2008 15:02:08 GMT

hi,

GO to transaction code su3 and change the user setting

go to defaults and changes the decimal notation.

Regards,

Himanshu Verma

Re: How to Replace ',' with '.' in workarea

gabriel_braun — Tue, 27 May 2008 15:02:23 GMT

shama,

You have to define the Decimal Notation with the transaction SU3 in the tab Defaults.

There are three different standard Decimal Notations avaiable in the SAP system.

You have to select the one that you need and hit the save key.

After that you have to log off the system and log in again.

Good Luck

Gabriel

Re: How to Replace ',' with '.' in workarea

Former Member — Tue, 27 May 2008 15:03:36 GMT

Got to System->User Profile->User Defaults .The maintain user default screen is displayed.

In decimal notation box , choose the option u wanted.

press save button on application tool bar.

Choose the menu path System->Log Off. The log off dialog box is displayed.

press yes button.you will be logged off from the systm

New user defauls will be in effect the next time you log in.

Reward If helpful

Re: How to Replace ',' with '.' in workarea

Former Member — Tue, 27 May 2008 15:08:33 GMT

hi,

do like this.

System -> User Profile -> own data -> there one tab wil be there "DEFAULTS" -> There you need to change DECIMAL NOTATION.

regards'

Sandeep REddy

Re: How to Replace ',' with '.' in workarea

Former Member — Tue, 27 May 2008 16:21:37 GMT

Hi,

to change from , to . use

translate <value> using ',.'

Regards

Jaime

Edited by: Jaime Cordeiro on May 27, 2008 5:21 PM

Re: How to Replace ',' with '.' in workarea

Former Member — Wed, 28 May 2008 05:05:36 GMT

Hello Rahul,

The best & easiest way is to use REPLACE ALL OCCURENCES OF .

This is rather more flexible ,

For Egu2026.When you have a requiremnet to replace all the commas with spaces you can use the following syntaxu2026u2026.

REPLACE ALL OCCURRENCES OF ',' IN wa_final-last_name WITH ' .' .

Or u can go using one FM

Replace the special Characters.

Try using this function - it replaces special characters:

SCP_REPLACE_STRANGE_CHARS

This function module replaces special characters like ñ,Í,ü,ú,á,é,ó etc with n,I,u,a,e,ou2026

Try it, It works

Regards

Rohini devi.