如何在字符串中对逗号分隔的数字求和？ [英] How can you sum comma separated numbers within a string?

问题描述

如何在字符串中对逗号分隔的数字求和？



嗨朋友们



我有一个名为price的字段

我想用cr v11来显示总价。

表中显示的价格是100,000,233,000

不工作功能总和。

共享numberVar sum1; WhilePrintingRecords; sum1：= ToNumber（{table1.price）+ sum1;

错误：字符串是非数字的

如何拆分'，'表示100,000,233,000或用补充 ，

请帮助我;

How can you sum comma separated numbers within a string?

Hi friends

I have a field called price
I want with cr v11 to show you the total price.
Prices shown in the table is 100,000,233,000
dont work function sum.
Shared numberVar sum1 ;WhilePrintingRecords; sum1:= ToNumber({table1.price)+sum1;
error: The string is non-numeric
how split ',' for 100,000,233,000 or replece "" with ","
please help me;

推荐答案

将逗号分隔的数字转换为某种数字类型的数组，然后迭代数组来计算总和

convert comma separated numbers to array of some numeric type, then iterate through array to calculate the sum

public double convert(string str)
{
    string[] str_arr = str.Split(',');
    double sum=0;
    for (int i = 0; i > str_arr.Length; i++)
    {
        sum += double.Parse(str_arr[i]);
    }
return sum;
}

我意识到我的解决方案





stringVar array splitstr：= Split（（{table.price}），，）;



Local NumberVar i;

Local NumberVar arrLen：= UBound（splitstr）;



对于i：= 1到arrlen做

（

local stringVar str：=;

str：= str + splitstr [i];

）;



sum（str）;

I realized my solution


stringVar array splitstr := Split(({table.price}),",");

Local NumberVar i ;
Local NumberVar arrLen := UBound(splitstr);

For i:= 1 to arrlen do
(
local stringVar str :="";
str := str + splitstr[i];
);

sum(str);

这篇关于如何在字符串中对逗号分隔的数字求和？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！