Tài khoản
function removeLinks() {
var sheet = SpreadsheetApp.getActiveSheet();
var dataRange = sheet.getDataRange();
var values = dataRange.getValues();
for (var i = 0; i < values.length; i++) {
for (var j = 0; j < values[i].length; j++) {
if (typeof values[i][j] === ‘string’) {
values[i][j] = values[i][j].replace(/http[s]?:\/\/.*/g, ”);
}
}
}
dataRange.setValues(values);
}