Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

7 REPLIES 7

Former Member
0 Kudos

U have to do in User setings

Former Member
0 Kudos

hi,

GO to transaction code su3 and change the user setting

go to defaults and changes the decimal notation.

Regards,

Himanshu Verma

gabriel_braun
Explorer
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

to change from , to . use

translate <value> using ',.'

Regards

Jaime

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

Former Member
0 Kudos

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.