title: How to ignore empty cell values for getRange().getValues()
body: <p>I am able to get the range values using getValues() and put it into a string by declaring the following variables in Google App Script</p>
  
  <pre><code>var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  var sheet = ss.getSheetByName("Test"); 
  var range_input = ss.getRange("A1:A").getValues();
  </code></pre>
  
  <p>However, I realize I am getting a lot of commas in my string probably from all the empty calls.</p>
  
  <p>For example, if values are following</p>
  
  <pre><code>================
  Spreadsheet("Test") Values
  
  A1=abc
  A2=def
  A3=    
  A4=
  A5=
  A6=uvw
  A7=xyz
  ================
  </code></pre>
  
  <p>If I do msgBox, it gets something like below.</p>
  
  <pre><code>Browser.msgBox(range_input) // results = abc,def,,,,uvw,xyz,,,,,,,,,,,
  </code></pre>
  
  <p>Is there a way to remove the trailing commas so I get something like below?
  (i.e. ignore the empty cells)</p>
  
  <pre><code>Browser.msgBox(range_input) // results = abc,def,uvw,xyz
  </code></pre>