I have a csv file :
name,number,level Mike,b1,0 Tom,b2,0 ..... I want to construct something like:
matrix: { { name: 'Mike', number: 'b1', level: 0 }, { name: 'Tom', number: 'b2', level: 0 }, .... } and I want to be able to extract the properties,for example matrix.name.
My problem is that I want to search later using ejs file by name for example.
I'm going to assume you already have the CSV data loaded. If not, you can refer to this question on how to load that data into your application.
Going from there, I'm going to assume your data is stored in a variable called csv. What you need to do is first process each line of that data and split the values on commas. After that, it's as simple as creating a new object which each value and adding that object to an array.
var csv = 'name,number,level\n' + 'Mike,b1,0\n' + 'Tom,b2,0'; // Split the data into individual lines by splitting on the line break var lines = csv.split('\n'); // I'm going to store the column names so I can use them to automatically get each value // Note that I also removed the columns from the `lines` array so it won't be there when we go through it var columns = lines.shift(); // Make sure we split on the commas columns = columns.split(','); // Create an array for us to store the objects in var matrix = []; // Next, we begin processing each line for (var i = 0, len = lines.length; i < len; i++) { var line = lines[i]; // Each value is separated by a comma. Split the line on those commas var values = line.split(','); // Now we create a new object that we'll store each value in var obj = {}; // Remember that `columns` array? We're going to use that to generate our keys for (var j = 0, numOfColumns = columns.length; j < numOfColumns; j++) { // This is going to be 'name', 'number', and 'level' var column = columns[j]; // Here is where we extract the matching value var value = values[j]; // Now we add a new property to that new object using the `column` as the key // and the `value` as, well, the value obj[column] = value; } // The object has been generated, add it to the array matrix.push(obj); } // Display the complete array document.querySelector('pre').innerText = JSON.stringify(matrix, null, 2);<pre></pre>
using the names as a key for the rest of the properties (for example matrix.Mike = { number: 'b1', level: 0 })? (upvoted)
matrix an object (var matrix = {}) and you do matrix[values[0]] = obj. values[0] will be the name so you'll just be adding a new property to matrix that matches that name.matrix.name or matrix.number and give me the results?matrix has a property of name. I get the feeling you work with MatLab a lot or something. There's nothing in Javascript that would allow you to write matrix.name and get all of the names. The only way you could do that is if you created a property of matrix called name that contained each of the names in it. But that would (probably) only have the names, not the rest of the data. You need to decide how you want to access your data. This is becoming a bit of a running in circles thing.
matrix = [ { name: 'Mike', number: 'b1', level: 0 }, { name: 'Tom', number: 'b2', level: 0 }, ... ]. You might also consider using the names as a key for the rest of the properties (for examplematrix.Mike = { number: 'b1', level: 0 }).