Application Development and Automation 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: 
Read only

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

Former Member
0 Likes
8,286

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

1 ACCEPTED SOLUTION
Read only

Former Member
3,445

Hi,

Use


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

Regards

Debarshi

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

4 REPLIES 4
Read only

Former Member
3,446

Hi,

Use


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

Regards

Debarshi

Read only

Former Member
0 Likes
3,445

Use Replace statement.

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

Regards,

Aparna

Read only

JozsefSzikszai
Active Contributor
3,445
TRANSLATE string USING ',.'.
Read only

Former Member
0 Likes
3,445

Resolved