Remove empty arrays from csv output

Question

I'm using this script to download all tabs in a Google spreadsheet.

When I output the rows being downloaded, it's including blank arrays:

Output: Data 1: [[id, name], [1.0, John], [2.0, Smith], [, ], [, ], [, ], [, ], [, ], [, ], ...

function convertRangeToCsvFile_(csvFileName, sheet) {
  // get available data range in the spreadsheet
  var activeRange = sheet.getDataRange();
  try {
    var data = activeRange.getValues();
    Logger.log('Data 1: %s', data); <----- Logging here

How can I clear this out from the final downloaded csv?

thealpha93 · Accepted Answer · 2020-06-09 14:46:01Z

1

You can try this. This code filters and returns an array with the sub arrays of length greater than 1

var data = activeRange.getValues();
const filteredData = data.filter(item => item.length > 1);

answered Jun 9, 2020 at 14:46

thealpha93

7864 silver badges15 bronze badges

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

Comments

Nicolás Campos · Accepted Answer · 2020-06-09 15:18:14Z

Question: why are you using %s to log it? Given that what you are logging is actually an array it might cause some issues.

It seems that in the script you've shown they perform some kind of filtering between row and columns and they parse it into a string later on, I suggest you try something like this:

const data = activeRange.getValues();
const filteredData = data.filter((item) => {
  // We will prevent non array elements that could break the your csv grid here
  if (!Array.isArray(item)){
    return false
  }
  // We will prevent rows with funny values (or no values) here
  for (var column = 0; column < item.length; column++) {
    if(!item[column]) {
      return false;
    }
  }
  // Add any extra condition before this return statement which basically means they are good to go
  return true;
});

And then apply the proper parsing to string or whatever you need to pass on to your csv file.

Collectives™ on Stack Overflow

Remove empty arrays from csv output

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related