Using js remove comma from number from existing data [duplicate]

Question

The array data is

[{
  "Date": "2018-03-20",
  "Total": "10,459"
}, {
  "Date": "2018-03-21",
  "Total": "11,947"
}, {
  "Date": "2018-03-22",
  "Total": "12,932",
}];

And I need to be like this:

[{
  "Date": "2018-03-20",
  "Total": "10459"
}, {
  "Date": "2018-03-21",
  "Total": "11947"
}, {
  "Date": "2018-03-22",
  "Total": "12932",
}];

Please show us what have you tried so far. Are you stuck on some specific step when implementing this? — Ionut Necula
– Ionut Necula, Commented Oct 16, 2018 at 11:25
@lonut i have only this json the things i done its fine now what i have to do is to remove comma from number inside total. — Prakash Pandey
– Prakash Pandey, Commented Oct 16, 2018 at 11:28
Since it's a string, just use a simple .replace(). For the record, this is a good example of why we save integers as actual integers instead of some language based string, since doing that would avoid this entire problem. ( and probably other problems not asked about ) — Shilly
– Shilly, Commented Oct 16, 2018 at 11:31

Mamun · Accepted Answer · 2018-10-16 11:35:26Z

0

Use Array.prototype.map() and String.prototype.replace() to modify the property Total:

var data = [{"Date": "2018-03-20", "Total": "10,459"},{"Date": "2018-03-21", "Total": "11,947"},{"Date": "2018-03-22", "Total": "12,932",}];

data = data.map(i => {
  i.Total = i.Total.replace(/,/g,'');
  return i;
});
console.log(data);

edited Oct 16, 2018 at 11:35

answered Oct 16, 2018 at 11:28

Mamun

69k9 gold badges51 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mplungjan Over a year ago

Your json is not json, it is just a javascript object array

Prakash Pandey Over a year ago

@mamun thanks it works :)

Mamun Over a year ago

@PrakashPandey, you are most welcome :)

void · Accepted Answer · 2018-10-16 11:28:37Z

0

You can use .map for this and inside its callback replace the comma

const x = [{
  "Date": "2018-03-20",
  "Total": "10,459"
}, {
  "Date": "2018-03-21",
  "Total": "11,947"
}, {
  "Date": "2018-03-22",
  "Total": "12,932",
}];

const y = x.map(el => {
  el.Total = el.Total.replace(/,/g, "");
  return el;
})

console.log(y);

answered Oct 16, 2018 at 11:28

void

36.7k10 gold badges71 silver badges111 bronze badges

Comments

Nick Parsons · Accepted Answer · 2018-10-16 11:28:47Z

0

You can use the map function and the replace function to remove the commas from the Total

let data = [{
  "Date": "2018-03-20",
  "Total": "10,459"
}, {
  "Date": "2018-03-21",
  "Total": "11,947"
}, {
  "Date": "2018-03-22",
  "Total": "12,932",
}];

let res = data.map(elem => {
  elem.Total = elem.Total.replace(',', '');
  return elem;
})

console.log(res);

answered Oct 16, 2018 at 11:28

Nick Parsons

51.7k6 gold badges61 silver badges80 bronze badges

Comments

Sumesh TG · Accepted Answer · 2018-10-16 11:31:53Z

0

Using JQuery

var data=[{
  "Date": "2018-03-20",
  "Total": "10,459"
}, {
  "Date": "2018-03-21",
  "Total": "11,947"
}, {
  "Date": "2018-03-22",
  "Total": "12,932",
}];
$.each(data,function(index,item){
  item.Total=item.Total.replace(",","");
   console.log(item);
});

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

use $.each to iterate over an object.

answered Oct 16, 2018 at 11:31

Sumesh TG

2,5732 gold badges17 silver badges29 bronze badges

1 Comment

Shilly Over a year ago

$.each() => data.forEach() JQuery isn't mentioned anywhere in the question.

Bharata · Accepted Answer · 2019-12-14 16:18:09Z

0

Simple solution would be to use parseFloat:

 const data = [{
      "Date": "2018-03-20",
      "Total": "10,459"
    }, {
      "Date": "2018-03-21",
      "Total": "11,947"
    }, {
      "Date": "2018-03-22",
      "Total": "12,932",
    }];  

      data.map(row => {
          row.Total = parseFloat(row.Total.replace(/,/g, ''));
        })

edited Dec 14, 2019 at 16:18

Bharata

14.2k6 gold badges44 silver badges54 bronze badges

answered Oct 16, 2018 at 11:28

Dinosan0908

1,1022 gold badges8 silver badges20 bronze badges

1 Comment

mplungjan Over a year ago

row.Total = +(row.Total.replace(/,/g, ''));

Collectives™ on Stack Overflow

Using js remove comma from number from existing data [duplicate]

5 Answers 5

3 Comments

Comments

Comments

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

Comments

1 Comment

1 Comment

Linked

Related