How SUM array json using jquery

Question

How can I to sum elements of a JSON array like this, using jQuery:

{"formulagram":"470+6,7+33,5+236,2+4,5+0,3"}

and the result should be :

total : 751,2

Nominal with comma and + is a sparator.

Thank you

What does the comma in 751,2 separate? You need to elaborate more on what is being summed. — Austin Brunkhorst
– Austin Brunkhorst, Commented Jan 13, 2016 at 3:18
@AustinBrunkhorst : total shown are not always round. but also coma and + serves merely as a separator nominal figures such as coma if nominal not with commas. — riski maker
– riski maker, Commented Jan 13, 2016 at 3:25

vsogrimen · Accepted Answer · 2016-01-13 04:01:00Z

TRY THIS:

var objForm = {
    formulagram:"470+6,7+33,5+236,2+4,5+0,3"
};

var str= objForm.formulagram;

str = str.split(',').join('.').split('+');

var total = 0;
$.each(str,function() {
    total += parseFloat(this);
});

total = Math.round(total * 100) / 100;

total = total.toString().replace('.',',');

console.log(total);

I have created a demo below:

var objForm = {
  formulagram: "470+6,7+33,5+236,2+4,5+0,3"
};

var str = objForm.formulagram;

str = str.split(',').join('.');

$('#splitbyComma').html(str);

str = str.split('+');

var total = 0;
$.each(str, function() {
  total += parseFloat(this);
});

total = Math.round(total * 100) / 100;

total = total.toString().replace('.',',');

$('#result').html(total);

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

<p>Replace Comma with dot (.)</p>
<p id="splitbyComma"></p>
<p><strong>Total:</strong>
</p>
<p id="result"></p>

Jason Kennaly · Accepted Answer · 2016-01-13 03:36:52Z

0

Here's a more roundabout but automated way:

var formulaObject = JSON.parse({"formulagram":"470+6,7+33,5+236,2+4,5+0,3"})
var formulaString = formulaObject.formulagram
var formulaPoint = formulaString.replace(',', '.')
var formulaArray = formulaPoint.split('+')
var formulaSum = formulaArray.reduce(function(prev, cur) {
    return prev + parseFloat(cur)
}, 0)

answered Jan 13, 2016 at 3:36

Jason Kennaly

6511 gold badge5 silver badges9 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:52:00Z

0

You have to replace the character ',' for '.' to represent floating numbers. Then you can use eval.

Code:

var str= "470+6.7+33.5+236.2+4.5+0.3";
var sum = parseFloat(eval(str));

You have to be careful because it can be risky to use eval. Read more in this thread Why is using the JavaScript eval function a bad idea?

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Jan 13, 2016 at 3:24

iamdeit

6,1355 gold badges30 silver badges44 bronze badges

1 Comment

Austin Brunkhorst Over a year ago

Obligatory comment about security implications of eval.

Collectives™ on Stack Overflow

How SUM array json using jquery

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related