CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetssplitsubstringtrim
Genny
Genny

Reputation: 143

Google Apps Script Trim White Space at the beginning of a string for an entire column

Sample Spreadsheet Tab - Result

I want to remove spaces in front of the text in Col. B

None of the codes I tried seem to be working. I tried the replace method, then split & join. But it still leaves a blank space in front of the text.

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheetname = "Result";
  var sheet = ss.getSheetByName(sheetname);
  sheet.getRange('B2:B').activate();
  var ranges = sheet.getActiveRangeList().getRanges();
  for (var i = 0; i < ranges.length; i++) {
    ranges[i].getValue().split(' ').join('');

I did numerous searches in stack and Google, but none of them seem to work. What am I doing wrong here?

Upvotes: 2

Views: 9060

Answers (2)

David Aguiar Aquino Paiva
David Aguiar Aquino Paiva

Reputation: 44

try adding replaceAll(" ","") to your string:

ranges[i].getValue().replaceAll(" ","")

Upvotes: 1

Lorena Gomez
Lorena Gomez

Reputation: 2203

I don't see data in Tab 'Result' - Column B to test it out but if you're just trying to remove blank space from the beginning of the text in a range, you can try:

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheetname = "Result";
  var sheet = ss.getSheetByName(sheetname);
  
  var lastRow = sheet.getLastRow();
  var range = sheet.getRange("B2:B"+lastRow);
  range.trimWhitespace();

Upvotes: 3

Related Questions