topic Re: How to replace comma(,) with a dot(.) in a string. in Application Development and Automation Discussions

How to replace comma(,) with a dot(.) in a string.

Former Member — Thu, 06 Nov 2008 08:32:29 GMT

Hi,

I need to replace comma(,) with a dot(.) in a string. i.e if the string has the value 80,000 then it shoudl be converted to 80.000. Please suggest an approach.

Thanks in advance,

Anushree

Re: How to replace comma(,) with a dot(.) in a string.

Former Member — Thu, 06 Nov 2008 08:38:45 GMT

Hi,

Use


replace all occurrences of ',' in <your field name> with '.'.

Regards

Debarshi

Re: How to replace comma(,) with a dot(.) in a string.

Former Member — Thu, 06 Nov 2008 08:38:50 GMT

Use Replace statement.

REPLACE ALL OCCURRENCES OF ',' WITH '.' INTO string.

Regards,

Aparna

Re: How to replace comma(,) with a dot(.) in a string.

JozsefSzikszai — Thu, 06 Nov 2008 08:40:26 GMT

TRANSLATE string USING ',.'.

Re: How to replace comma(,) with a dot(.) in a string.

Former Member — Tue, 10 Mar 2009 10:09:39 GMT

Resolved