Retrieving cells without blank using GAS

GasTips
Google Apps Script

This is a sample script for retrieving cells without blank cells. Figure 1 shows the sample spreadsheet. In this sheet, the row 14 has one space.
Fig. 1: Sample spreadsheet.

Data is retrieved as follows.

  var data = SpreadsheetApp
             .getActiveSpreadsheet()
             .getActiveSheet()
             .getRange('a1:a30')
             .getValues();

1. Retrieving cells with spaces and no blank cells.

  var Result = [i for each (i in data)if (i)].join('');

Result : Hello World

2. Retrieving cells without both spaces and blank cells.

  var Result = [i for each (i in data)if (isNaN(i))].join('');

Result : HelloWorld

 Share!