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. — Ali
– Ali, Commented Dec 18, 2018 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
– Matthew Herbst, Commented Dec 18, 2018 at 18:55
What does the rows array return? Please log it to the console and add the code.@AhmadSayedAbdulrahman — Lloyd Nicholson
– Lloyd Nicholson, Commented Dec 18, 2018 at 19:35

Matthew Herbst · Accepted Answer · 2018-12-18 21:42:01Z

2

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] };
});

answered Dec 18, 2018 at 21:42

Matthew Herbst

32.3k27 gold badges92 silver badges141 bronze badges

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

Collectives™ on Stack Overflow

Delete item from dataarray

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related