Delete item from dataarray

Question

I have a script in which the row data of a google sheet is stored into a JSON. I'd like to filter the data that is stored in the array.I don't want the empty cells to be inserted into the array. I want only the filled cells to be inserted into the array .Here is the script I'm using

  var dataArray = [];
  var rows = sheet.getRange(2,1,sheet.getLastRow()-1, sheet.getLastColumn()).getValues();

  for(var i = 0, l= rows.length; i<l ; i++){
    var dataRow = rows[i];
    var record = {};
    record['name'] = dataRow[0];
    record['age'] = dataRow[1];
    record['weight'] = dataRow[2];

    dataArray.push(record);   
  }

The cells are copied from another sheet. So, the array records all the copied range even if the cell is empty. — Ahmad Sayed Abdulrahman, Dec 18 '18 at 18:54
Right. And you want to filter out empty cells. So, how do you know if a cell is empty? Will `dataRow[0]` be `undefined` for example? — Matthew Herbst, Dec 18 '18 at 18:55
What does the rows array return? Please log it to the console and add the code.@AhmadSayedAbdulrahman — Lloyd Nicholson, Dec 18 '18 at 19:35
Possible duplicate of [How do I remove a particular element from an array in JavaScript?](https://stackoverflow.com/questions/5767325/how-do-i-remove-a-particular-element-from-an-array-in-javascript) — Lloyd Nicholson, Dec 18 '18 at 19:52
Your link is about an array with one row and many columns but my array is n*n @LloydNicholson — Ahmad Sayed Abdulrahman, Dec 18 '18 at 20:18
@AhmadSayedAbdulrahman can you reply to my question above then so I can try help you. — Lloyd Nicholson, Dec 18 '18 at 20:23

score 2 · Answer 1 · answered Dec 18 '18 at 21:42

I think what you're really looking for is the .filter method to get rid of the empty cells, and then you can use a .map to transform them:

var rows = sheet.getRange(
  2,
  1,
  sheet.getLastRow() - 1,
  sheet.getLastColumn()
).getValues();

var filteredDataArray = rows.filter(function(row) {
  return row[0] !== ''; // Based on your comment that "empty" means it's an empty string
});

var transformedDataArray = filteredDataArray.map(function(row) {
  return { name: row[0], age: row[1], weight: row[2] };
});

Delete item from dataarray

1 Answers1