Google 表格替换回车符

Javascript
function replaceLineBreaks() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  
  for (var i = 0; i < values.length; i++) {</p>    for (var j = 0; j < values[i].length; j++) {</p>      if (typeof values[i][j] === 'string') {
        var newValue = values[i][j].replace(/\n/g, ''); // 替换回车符
        values[i][j] = newValue;
      }
    }
  }
  
  range.setValues(values);
}