remove _ from a json using javascript

Question

Below, I have json from which I want to remove underscores. Here is what I tried.

I am getting getting "replace is not a function".

  var y= {
                "QUESTION_MARKS": {
                                "count": 390,
                                "percentage": 8.8
                },
                "NEARLY_ACTIVATED": {
                                "count": 710,
                                "percentage": 16
                },
                "MOST_VALUBLE_SUBSCRIBERS": {
                                "count": 1650,
                                "percentage": 37.2
                },
                "LIKELY_TO_THRIVE": {
                                "count": 300,
                                "percentage": 6.8
                },
                "EMAIL_ENGAGE": {
                                "count": 420,
                                "percentage": 9.5
                },
                "EMAIL_INACTIVE": {
                                "count": 32,
                                "percentage": 0.7
                },
                "NEVER_ACTIVATED": {
                                "count": 930,
                                "percentage": 21
                }
};
    var yformatted=y.replace(/[_-]/g, " "); 
    easeSummary=yformatted;

you can try JSON.stringify to convert it to a string, remove underscores, then JSON.parse to parse it back to an object. Not sure if it will work — Chris Li
– Chris Li, Commented Sep 24, 2018 at 15:49

Brank Victoria · Accepted Answer · 2018-09-24 15:50:39Z

2

You must convert your JSON object to a String, then you can use replace function to do what you are looking for

var yformatted=JSON.stringify(y).replace(/[_-]/g, " ");

answered Sep 24, 2018 at 15:50

Brank Victoria

1,48511 silver badges18 bronze badges

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

Comments

Shubham Gupta · Accepted Answer · 2018-09-24 15:52:29Z

For replace to work you need to convert your object to string and then replace _. Once that it is done convert it back to object. Take a look at below snippet.

var y = {
  "QUESTION_MARKS": {
    "count": 390,
    "percentage": 8.8
  },
  "NEARLY_ACTIVATED": {
    "count": 710,
    "percentage": 16
  },
  "MOST_VALUBLE_SUBSCRIBERS": {
    "count": 1650,
    "percentage": 37.2
  },
  "LIKELY_TO_THRIVE": {
    "count": 300,
    "percentage": 6.8
  },
  "EMAIL_ENGAGE": {
    "count": 420,
    "percentage": 9.5
  },
  "EMAIL_INACTIVE": {
    "count": 32,
    "percentage": 0.7
  },
  "NEVER_ACTIVATED": {
    "count": 930,
    "percentage": 21
  }
};
var yformatted = JSON.stringify(y).replace(/[_-]/g, " ");
var easeSummary = JSON.parse(yformatted);
console.log(easeSummary);

Michael Hurley · Accepted Answer · 2018-09-24 15:54:48Z

See this fiddle for an example of using for(in): http://jsfiddle.net/craftman32/djb1m7p0/

 var y = {
   "QUESTION_MARKS": {
     "count": 390,
     "percentage": 8.8
   },
   "NEARLY_ACTIVATED": {
     "count": 710,
     "percentage": 16
   },
   "MOST_VALUBLE_SUBSCRIBERS": {
     "count": 1650,
     "percentage": 37.2
   },
   "LIKELY_TO_THRIVE": {
     "count": 300,
     "percentage": 6.8
   },
   "EMAIL_ENGAGE": {
     "count": 420,
     "percentage": 9.5
   },
   "EMAIL_INACTIVE": {
     "count": 32,
     "percentage": 0.7
   },
   "NEVER_ACTIVATED": {
     "count": 930,
     "percentage": 21
   }
 };

var newObject = {};

for (key in y) {
  newObject[key.replace(/[_-]/g, " ")] = y[key];
}

console.log(newObject);

In this example, newObject is created that has the same properties as y but with _ removed in each property name.

Ram · Accepted Answer · 2018-09-24 15:56:32Z

1

replace is a a method of string objects. y in your code is a plain object. Plain objects do not have replace method. You can JSON stringify the object and then use the replace method. This may have unwanted side effects as it seems you only want to modify the keys. I'd suggest creating a new object:

const x = Object.keys(y).reduce((ret, key) => {
  let nkey = key.replace(/[_-]/g, " ");
  ret[nkey] = y[key];
  return ret;
}, {});

answered Sep 24, 2018 at 15:56

Ram

145k16 gold badges174 silver badges201 bronze badges

Comments

Wolfyr · Accepted Answer · 2018-09-24 15:55:50Z

0

These are a few ways to tackle this problem. Here is an other Stackoverflow link addressing this problem: JavaScript: Object Rename Key

answered Sep 24, 2018 at 15:55

Wolfyr

4893 silver badges12 bronze badges

Comments

Andy · Accepted Answer · 2018-09-24 16:11:43Z

0

Using this SO answer as a template you could write a function to return a new object with new keys:

var y = {"QUESTION_MARKS":{"count":390,"percentage":8.8},"NEARLY_ACTIVATED":{"count":710,"percentage":16},"MOST_VALUBLE_SUBSCRIBERS":{"count":1650,"percentage":37.2},"LIKELY_TO_THRIVE":{"count":300,"percentage":6.8},"EMAIL_ENGAGE":{"count":420,"percentage":9.5},"EMAIL_INACTIVE":{"count":32,"percentage":0.7},"NEVER_ACTIVATED":{"count":930,"percentage":21}};

function removeUSFromKey(obj) {
  const keys = Object.keys(obj).map(key => {
    const newKey = key.replace(/_/g, '');
    return { [newKey]: obj[key] };
  });
  return Object.assign({}, ...keys);
}

console.log(removeUSFromKey(y))

answered Sep 24, 2018 at 16:11

Andy

63.7k13 gold badges72 silver badges99 bronze badges

Comments

Mile · Accepted Answer · 2019-12-14 01:46:53Z

Wrap your object in string templates because is a multi-line object and then could apply to replace().

var y= `{
  "QUESTION_MARKS": {
                  "count": 390,
                  "percentage": 8.8
  },
  "NEARLY_ACTIVATED": {
                  "count": 710,
                  "percentage": 16
  },
  "MOST_VALUBLE_SUBSCRIBERS": {
                  "count": 1650,
                  "percentage": 37.2
  },
  "LIKELY_TO_THRIVE": {
                  "count": 300,
                  "percentage": 6.8
  },
  "EMAIL_ENGAGE": {
                  "count": 420,
                  "percentage": 9.5
  },
  "EMAIL_INACTIVE": {
                  "count": 32,
                  "percentage": 0.7
  },
  "NEVER_ACTIVATED": {
                  "count": 930,
                  "percentage": 21
  }
}`;
var yFormatted= y.replace(/_/g,' ');

The solved problem is here: MissyM stackblitz

Collectives™ on Stack Overflow

remove _ from a json using javascript

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related