How to check if a value exists in json array? If match is found, delete the key value pair

Question

I have a sharepoint column named AllLinks in which im storing array as:

[{"AllLinks":"Link9","LinkURL":"http://www.Link9.com"},   
 {"AllLinks":"Link6","LinkURL":"http://www.Link6.com"}]

How to check if a value exists in an array of objects and if a match is found, delete the key value pair.

For example if the value Link6 matches, delete the entry completely from the array using javascript/jquery. I tried with:

var newA = data.d.results.filter(function (item) return item.AllLinks !== x;});

but item.AllLinks again returns the complete array itself

as AllLinks is a column in my sharepoint list.

you want to remove it before or without json decode in js ?? — Faisal Mehmood Awan
– Faisal Mehmood Awan, Commented Aug 17, 2017 at 10:32
Note that nothing about this is JSON. I changed the title, description and tags for you. — Rory McCrossan
– Rory McCrossan, Commented Aug 17, 2017 at 10:35
But in many json validators it comes out as valid json.Is it really not json and just array of objects? — saumya bhargava
– saumya bhargava, Commented Aug 17, 2017 at 10:48

José Quinto Zamora · Accepted Answer · 2017-08-17 10:33:42Z

6

You can use filter function:

var a = [{"AllLinks":"Link9","LinkURL":"http://www.Link9.com"},{"AllLinks":"Link6","LinkURL":"http://www.Link6.com"}]

var newA = a.filter(function (item) {
    return item.AllLinks !== "Link6";
});

answered Aug 17, 2017 at 10:33

José Quinto Zamora

2,13815 silver badges15 bronze badges

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

Comments

Ankit Agarwal · Accepted Answer · 2017-08-17 10:37:02Z

5

You can do this in such an easy way here:

var jsonArry = [{"AllLinks":"Link9","LinkURL":"http://www.Link9.com"},{"AllLinks":"Link6","LinkURL":"http://www.Link6.com"}];

var value = "Link6";

for(var i=0; i<jsonArry.length; i++){
   if(jsonArry[i].AllLinks === value){
        jsonArry.splice(i,1);
   }
}

console.log(JSON.stringify(jsonArry));

If you are sure that the value key is unique then add a break keyword inside the for loop within if after you delete the object so as to prevent unnecessary loops like this,

for(var i=0; i<jsonArry.length; i++){
   if(jsonArry[i].AllLinks === value){
       jsonArry.splice(i,1);
       break;
   }
}

edited Aug 17, 2017 at 10:37

answered Aug 17, 2017 at 10:32

Ankit Agarwal

30.8k5 gold badges41 silver badges63 bronze badges

2 Comments

PeterMader Over a year ago

Can't you see that the array item isn't really removed? You still have null in there, which is not what the OP wants.

Ankit Agarwal Over a year ago

@PeterMader you are right. Thanks for improving. We can use splice in this case.

Collectives™ on Stack Overflow

How to check if a value exists in json array? If match is found, delete the key value pair

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related