topic Re: Replace dot ('.') by comma(','). in Application Development and Automation Discussions

Replace dot ('.') by comma(',').

Former Member — Thu, 20 Apr 2006 06:51:14 GMT

Hi All,

We need to place commas in place of dots as in neumeric figures.Though the user profile was changed but the change is not reflected in neumeric figures.

Can anyone help me on this matter?

Thx.

Atrai.

Re: Replace dot ('.') by comma(',').

Former Member — Thu, 20 Apr 2006 06:55:12 GMT

Hi Atrai,

Did you make the changes in the own data in user profiles...

if you have made..

try to log off and log in again..

regards

satesh

Re: Replace dot ('.') by comma(',').

Former Member — Thu, 20 Apr 2006 06:59:00 GMT

also try the OY01 setting..this may create problem sometimes...

OY01~~>country~~>check the decimal format..

hope it helps,

Regards,

Bikash

Re: Replace dot ('.') by comma(',').

Former Member — Thu, 20 Apr 2006 07:01:57 GMT

Hai Atrai,

Try check your user setting ?

menu system->user profile->own data

tab 'defaults'->decimal notation.

hope this helps.

Regards,

Srikanth

Re: Replace dot ('.') by comma(',').

Former Member — Thu, 20 Apr 2006 07:04:13 GMT

Hi Atrai,

You can use REPLACE:-

REPLACE <str1> WITH <str2> INTO <c> [LENGTH <l>].

The statement searches the field <c> for the first occurrence of the first <l> positions of the pattern <str1>. If no length is specified, it searches for the pattern <str1> in its full length.

Then, the statement replaces the occurrence of the pattern <str1> in field <c> with the string <str2>.

You will have to first convert the number to type char and then reassign it

Regards,

Sameena

Re: Replace dot ('.') by comma(',').

Former Member — Thu, 20 Apr 2006 07:09:36 GMT

Hello Atrai,

It is notjust user profile but other areas in customisation also which impacts what is getting pronted. Let us know what u are trying to do and where u want this to happen.

Re: Replace dot ('.') by comma(',').

andreas_mann3 — Thu, 20 Apr 2006 07:17:20 GMT

hi,

use: translate field using '.,'.

Andreas

Re: Replace dot ('.') by comma(',').

Former Member — Thu, 20 Apr 2006 08:39:00 GMT

Thx Bikash,my problem is solved.

Atrai.