Finding an array of data in an array of objects

Question

I have an array of values that looks like this:

["Ashar", 68345, 14, 46100, "Retail", 1, ""]

I also have an array of objects that looks like this:

[
 {id: 1, cells: ["Ashar", 68345, 14, 46100, "Retail", 1, ""]}, 
 {id: 2, cells: ["Ashar", 300881, 14, 37000, "Retail", 3, 3]}, 
 {id: 3, cells: ["Rob", 94448, 17, 11395, "Retail", 1, ""]}, 
 {id: 4, cells: ["Shahab", 19023870, 219, 12500, "Retail", 1, ""]}, 
 {id: 5, cells: ["David", 29008000, 229, 12500, "Retail", 5, 26]}
]

What I am trying to do is get the id in the object from the second array by matching the two arrays. I have written a find function which should in theory find the array of values in the second array so that I can access the id. However, it is returning undefined so something is clearly wrong with what I am doing.

Here is the code I currently have:

let row_id = rows.find(row => {
    dataEntriesArray === row.cells;
});

where rows is the second array and dataEntriesArray is the first one.

Any help in clearing this up for me would be much appreciated.

Thanks for your time.

var result = array.filter(function( obj ) { return obj.cells }); — Umair Khan
– Umair Khan, Commented May 26, 2016 at 9:42

Nina Scholz · Accepted Answer · 2016-05-26 09:46:08Z

1

This proposal checks every part of the cells array with the search array and returns the id, if found.

function getId(data, search) {
    var id;
    data.some(a => {
        if (a.cells.every((b, i) => b === search[i])) {
            id = a.id;
            return true;
        }
    });
    return id;
}

var search =["Ashar", 68345, 14, 46100, "Retail", 1, ""],
    data=    [{id: 1, cells: ["Ashar", 68345, 14, 46100, "Retail", 1, ""]}, {id: 2, cells: ["Ashar", 300881, 14, 37000, "Retail", 3, 3]}, {id: 3, cells: ["Rob", 94448, 17, 11395, "Retail", 1, ""]}, {id: 4, cells: ["Shahab", 19023870, 219, 12500, "Retail", 1, ""]}, {id: 5, cells: ["David", 29008000, 229, 12500, "Retail", 5, 26]}];

console.log(getId(data, search));

answered May 26, 2016 at 9:46

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

1 Comment

BeeNag Over a year ago

Exactly what I was looking for! Thanks for your help!

Rayon · Accepted Answer · 2016-05-26 09:44:03Z

1

Use Array#every

var ip1 = ["Ashar", 68345, 14, 46100, "Retail", 1, ""];

var ip2 = [{
  id: 1,
  cells: ["Ashar", 68345, 14, 46100, "Retail", 1, ""]
}, {
  id: 2,
  cells: ["Ashar", 300881, 14, 37000, "Retail", 3, 3]
}, {
  id: 3,
  cells: ["Rob", 94448, 17, 11395, "Retail", 1, ""]
}, {
  id: 4,
  cells: ["Shahab", 19023870, 219, 12500, "Retail", 1, ""]
}, {
  id: 5,
  cells: ["David", 29008000, 229, 12500, "Retail", 5, 26]
}];
var op = ip2.filter(function(item) {
  return item.cells.every(function(el) {
    return ip1.indexOf(el) > -1;
  })
});
console.log(JSON.stringify(op));

answered May 26, 2016 at 9:44

Rayon

36.6k5 gold badges54 silver badges78 bronze badges

Comments

Thorin · Accepted Answer · 2016-05-26 09:52:25Z

1

try this:

var search =["Ashar", 68345, 14, 46100, "Retail", 1, ""],
foundId = null,
a = [{id: 1, cells: ["Ashar", 68345, 14, 46100, "Retail", 1, ""]}, {id: 2, cells: ["Ashar", 300881, 14, 37000, "Retail", 3, 3]}, {id: 3, cells: ["Rob", 94448, 17, 11395, "Retail", 1, ""]}, {id: 4, cells: ["Shahab", 19023870, 219, 12500, "Retail", 1, ""]}, {id: 5, cells: ["David", 29008000, 229, 12500, "Retail", 5, 26]}];
search = search.sort().join();
a.forEach(function(entry) {
 if (entry.cells.sort().join() === search){
     foundId = entry.id;
   return;
 }
});

alert(foundId)

JS Fiddle

answered May 26, 2016 at 9:52

Thorin

2,0341 gold badge19 silver badges30 bronze badges

Comments

RomanPerekhrest · Accepted Answer · 2016-05-26 09:56:14Z

1

Short solution using Array.some and JSON.stringify functions:

var item = ["Rob", 94448, 17, 11395, "Retail", 1, ""],
    data = [{id: 1, cells: ["Ashar", 68345, 14, 46100, "Retail", 1, ""]}, {id: 2, cells: ["Ashar", 300881, 14, 37000, "Retail", 3, 3]}, {id: 3, cells: ["Rob", 94448, 17, 11395, "Retail", 1, ""]}, {id: 4, cells: ["Shahab", 19023870, 219, 12500, "Retail", 1, ""]}, {id: 5, cells: ["David", 29008000, 229, 12500, "Retail", 5, 26]}];

var id;
data.some((obj) => JSON.stringify(obj['cells']) === JSON.stringify(item) && (id = obj['id']), id);

console.log(id);  // 3

answered May 26, 2016 at 9:56

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

Collectives™ on Stack Overflow

Finding an array of data in an array of objects

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related