function getModifiedSheetNames() {
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
var sheetNames = sheets.map(sheet => sheet.getName());
var removeText = "_SIT"; // Change this to the text you want to remove
var addText = "https://telus-iot-5g.atlassian.net/browse/"; // Change this to the text you want to add
// Modify sheet names: Remove specific text and add new text
var modifiedSheetNames = sheetNames.map(name =>
addText+ name.replace(removeText, '').replace(/\s+/g, '')
);
return modifiedSheetNames;
}
No comments:
Post a Comment