topic Re: adding numbers - problem with comma in Application Development and Automation Discussions

adding numbers - problem with comma

Former Member — Tue, 25 Jul 2006 00:13:12 GMT

Hi folks,

I am trying to add two numbers in my code and some times the numbers have comma in them. For example the value 25.00 I have has 25,00. Now when I execute my program I am getting an error saying the numbers are not according to the standards of number formats.

Can someone please let me know how can I solve this problem. Thanks

Re: adding numbers - problem with comma

RichHeilman — Tue, 25 Jul 2006 00:17:03 GMT

You need to get rid of the commas in your fields that you want to add together. You can do that, with two lines of code.

translate v_field using ', '. 
condense v_field no-gaps.

Regards,

Rich Heilman

Re: adding numbers - problem with comma

abdul_hakim — Tue, 25 Jul 2006 00:22:13 GMT

try using the below code.

data: comma value ',',

deci value '.',

string(8),

string = '25,00'.

<b>replace comma with dec into string.</b>

Cheers,

Abdul Hakim

Re: adding numbers - problem with comma

RichHeilman — Tue, 25 Jul 2006 00:27:23 GMT

Didn't realize that we were talking about decimal separator, in that case, it is almost the same.



translate v_field using <b>',.'</b>. 
condense v_field no-gaps.

Regards,

Rich Heilman

Re: adding numbers - problem with comma

Former Member — Tue, 25 Jul 2006 00:29:58 GMT

Hi Rich,

For example I have the value 25,00 in the field 'Mvalue'. Where 25,00 actually means 25.00. Now I want to change the value in the field 'Mvalue' from 25,00 to 25.00.

Please help me.

Re: adding numbers - problem with comma

RichHeilman — Tue, 25 Jul 2006 00:35:23 GMT

The code in my last post should work for you. In my first answer, I was thinking that you needed to get rid of the comma because it was a thousands separator. I guess I didn't read your question carefully.

Regards,

Rich Heilman