How can you sum comma separated numbers within a string?

Question

1.00/5 (2 votes)

See more:

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;

Posted 15-May-11 8:36am

saedd3164

Updated 28-Apr-20 9:27am

Add a Solution

3 solutions

Solution 1

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

C#

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;
}

Posted 15-May-11 9:11am

dontumindit

Comments

saedd3164 16-May-11 14:28pm

is wrong

dontumindit 17-May-11 12:47pm

then what did u wanted exactly?

saedd3164 17-May-11 14:59pm

I realized my solution

dontumindit 18-May-11 14:10pm

ok, good.

Solution 5

you could use split.
Let assume your string is called S, using the For loop and Split, you could remove the comma:

for i in S.split(',')

In that line, i could be any variable and S is your string. You could also replace ',' with anything you want, whether it is a number you don't like or a letter. Hope this helped.

Posted 28-Apr-20 9:28am

Member 14816334

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

saedd3164 · Accepted Answer · 2011-05-17T08:57:00

Solution 2

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);

Posted 17-May-11 8:57am

saedd3164