How to split a javascript array using Google Script

Question

I'm working on a project that outputs a huge array, and I need to clean it up to send in an email. It seems the simplest approach is the split() function, but I can't seem to make it work.

function splitArray() {
var ss = SpreadsheetApp.getActiveSheet();
var row = ss.getLastRow();
var range = ss.getRange(row, 1, 1, ss.getMaxColumns());
var data = range.getValues();
data.split("\n");
Logger.log(data);}

Answer 1

You need to set the return value of data.split("\n"); to something. You are splitting the value successfully but not storing that value anywhwere

Try:

data = data.split("\n");

or

Logger.log(data.split("\n"));

• joshlsullivan: This looks great, except that Google returns this: "TypeError: Cannot find function split in object". I'm not sure Google Apps Script recognizes the split function.
• Andrew Hall: Seems like data is already an array. Try logging data before doing the split