當那個角色不存在時，我現在得到的結果讓我空白：
代碼
const categories = catSubSheet.getRange(2, 1, catSubSheet.getLastRow() - 1, 3).getValues();
let categories1 = categories.filter(e => e[0] != '').map(function (e) { return e[0] });
let sheetsToProcess = [];
for (let a = 0; a < categories1.length; a ) {
sheetNames = categories1[a].substring(0, categories1[a].indexOf(" ("));
sheetsToProcess.push('BOQ ' sheetNames)
}
資料
[
[GF HTG SHEET 1 (Drawing)],
[GF HTG SHEET 2 (Drawing)],
[GF DWS SHEET 1],
]
結果
Sheets to Process: BOQ GF HTG SHEET 1,BOQ GF HTG SHEET 2,BOQ
預期結果
Sheets to Process: BOQ GF HTG SHEET 1,BOQ GF HTG SHEET 2,BOQ GF DWS SHEET 1
uj5u.com熱心網友回復：
作為快速修復，您可以嘗試以下操作：
...
let sheetsToProcess = [];
for (let a = 0; a < categories1.length; a ) {
var index = categories1[a].indexOf(" (");
if (index > -1) { sheetNames = categories1[a].substring(0,index) }
else { sheetNames = categories1[a] }
sheetsToProcess.push('BOQ ' sheetNames)
}
...
但實際上它可以以更簡潔的方式完成。
像這樣的東西：
var categories1 = [
'GF HTG SHEET 1 (Drawing)',
'GF HTG SHEET 2 (Drawing)',
'GF DWS SHEET 1'
];
var sheetsToProcess = categories1.map(x => 'BOQ ' x.replace(/ \(. $/, ''));
console.log(sheetsToProcess); // [ 'BOQ GF HTG SHEET 1', 'BOQ GF HTG SHEET 2', 'BOQ GF DWS SHEET 1' ]轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/433679.html
標籤：javascript 细绳 谷歌应用脚本 谷歌表格