How to grab all non-empty cell data in row - Google Sheets Script Editor

Question

I'm not sure if this is even possible, and to be quite honest, I haven't tried many things because I wasn't sure where to even start. I'm using the Script Editor from Google Sheets, btw. I know there are SpreadsheetApp.getRange() and another to get the values or something like that. But what I want is a bit specific.

Is there a way to grab all the cell data in a given row and put it into an array? The rows will vary in size, that's why I can't do an exact range.

So for example, if I were to have rows have these values:

abc | 123 | 987 | efg
blah| cat | 654

I want to be able to grab those values and place them into an array like ["abc", "123", "987, "efg"]. And then if I run the function on the next row, it'd be ["blah", "cat", "654"].

Actually, it can be placed into any data type as long as there's a delimiter I'd be able to use.

Thank you in advance!

Answer 1

Is this useful for you?

When there are abc | 123 | 987 | efg, blah| cat | 654 and abc | | 987 | efg at row 1, row 2 and row 3, myFunction(1), myFunction(2) and myFunction(3) return [abc, 123.0, 987.0, efg], [blah, cat, 654.0] and [abc, , 987.0, efg].

function myFunction(row){
  var ss = SpreadsheetApp.getActiveSheet();
  var values = ss.getRange(row, 1, 1, ss.getLastColumn()).getValues();
  var c = 0;
  for (var c = values[0].length - 1; c >= 0; c--){
    if (values[0][c] != "") break;
  }
  values[0].splice(c + 1, values[0].length - c - 1);
  return values[0];
}