JSON replace all empty values with a default string

Question

JSON has many empty values, where I want to replace the empty value with a default string.

var json= [
{
    "machineNum": "1A",
    "serialNo": "123",
    "city": ""
},
{
    "machineNum": "2B",
    "serialNo": "",
    "city": ""
},
{
    "machineNum": "3A",
    "serialNo": "123",
    "city": "NewCity"
}
]

 var newJson=json.replace("","Not AVailable");
 console.log(newJson);

So wherever there is "" - empty value replace with default value "Not Available"

The above is not working.

JSFIDDLE here

It could work if you used it on the JSON string, and not the parsed JSON object. — doldt
– doldt, Commented Jul 2, 2015 at 12:32

brso05 · Accepted Answer · 2015-07-02 13:07:02Z

8

You need to do a replace on the json string not a javascript object. Also you aren't looking for "" you are looking for "\"\"":

var json= [
{
    "machineNum": "1A",
    "serialNo": "123",
    "city": ""
},
{
    "machineNum": "2B",
    "serialNo": "",
    "city": ""
},
{
    "machineNum": "3A",
    "serialNo": "123",
    "city": "NewCity"
}
]
var temp = JSON.stringify(json);
temp = temp.replace(/\"\"/g, "\"Not Available\"");
json = JSON.parse(temp);
console.log(json);

Console Output:

enter image description here

edited Jul 2, 2015 at 13:07

answered Jul 2, 2015 at 12:39

brso05

13.3k2 gold badges25 silver badges41 bronze badges

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

3 Comments

chirag Over a year ago

it is replacing the first occurrence of "" (empty). other remains "" (empty) instead of Not Available.

jpbaxxter Over a year ago

You could use the global modifier for the regex. Replace this line:>> temp = temp.replace(/""/g, "\"Not Available\"");

blueprintchris Over a year ago

Nice answer, +1

Shilly · Accepted Answer · 2015-07-02 12:40:34Z

3

If you don't want to stringify/reparse the json, you could loop over the array and each property of the objects in the array.

json.forEach(function (machine) {
    Object.keys(machine).forEach(function (key) {
        if (machine[key] === '' && machine.hasOwnProperty(key)) machine[key] = 'Not Available';
    });
});

answered Jul 2, 2015 at 12:40

Shilly

8,5991 gold badge20 silver badges24 bronze badges

Comments

TaoPR · Accepted Answer · 2015-07-02 12:47:19Z

1

You can use Array.prototype.map along with Object.keys to make sure all key-value pairs which have empty value are all applied with default string. See a quick example below:

function replaceEmpty(json, defaultStr){
    return json.map(function (el){
        Object.keys(el).forEach(function(key){
            el[key] = el[key] || defaultStr;
        });
        return el;
    });
}

var result = replaceEmpty(json,"Not Available");

Output

[{"machineNum":"1A","serialNo":"123","city":"Not Available"},{"machineNum":"2B","serialNo":"Not Available","city":"Not Available"},{"machineNum":"3A","serialNo":"123","city":"NewCity"}]

answered Jul 2, 2015 at 12:47

TaoPR

6,0783 gold badges28 silver badges38 bronze badges

Collectives™ on Stack Overflow

JSON replace all empty values with a default string

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related