Google Script实现仅完整单词替换的方法求助

问题背景 #

现有Google Script函数通过替换数组执行文本替换，但当前逻辑会匹配并替换字符串的部分内容（比如把Collins, Matthew James中的Collins, Matthew部分替换后，剩余内容拼接导致错误结果），需要修改为仅匹配并替换完整的目标字符串，确保所有测试用的姓名变体都能统一替换为Collins, Matthew。

原代码及问题 #

测试代码 #

function test_n() {
let  arr= [
 [ 'Collins, Matthew James'],
 [ 'Collins, Matthew'],
 [ 'Collins, Matthew J'],
 [ 'Collins, M. J.'],
 [ 'Collins, M.J.'],
 [ 'Collins, M.'],
 [ 'Collins, M.J'],
 [ 'Collins, M'],
 [ 'Collins, M J']
]

 let RgX = [
 [ 'Collins, Matthew James', 'Collins, Matthew' ],
 [ 'Collins, Matthew', 'Collins, Matthew' ],
 [ 'Collins, Matthew J', 'Collins, Matthew' ],
 [ 'Collins, M. J.', 'Collins, Matthew' ],
 [ 'Collins, M.J.', 'Collins, Matthew' ],
 [ 'Collins, M.', 'Collins, Matthew' ],
 [ 'Collins, M.J', 'Collins, Matthew' ],
 [ 'Collins, M', 'Collins, Matthew' ],
 [ 'Collins, M J', 'Collins, Matthew' ]
]

arr = processValues(arr, RgX)
console.log(arr)
}


function processValues(values, replaceTable) {
  return values.map(row =>
    row.map(c => c 
     ? replaceTable.reduce(
       (curString, tableEntry) => curString.replaceAll(...tableEntry)
       , c) : '', ""));
}

当前错误输出 #

[ [ 'Collins, Matthewatthew' ],
  [ 'Collins, Matthewatthew' ],
  [ 'Collins, Matthewatthew' ],
  [ 'Collins, Matthewatthew' ],
  [ 'Collins, Matthewatthew' ],
  [ 'Collins, Matthewatthew' ],
  [ 'Collins, MatthewatthewJ' ],
  [ 'Collins, Matthew' ],
  [ 'Collins, Matthew J' ] ]

尝试修改的问题 #

你之前尝试用正则边界\b但写法错误：new RegExp('\\b' + tableEntry[0] + '//b','g')，这里的//b是错误写法，应为\\b；同时未转义目标字符串中的特殊字符（比如逗号,、点号.），这些字符在正则中是特殊元字符，会导致匹配失败。

解决方案 #

1. 转义正则特殊字符：编写工具函数，将目标字符串中的.、(、)、空格等特殊字符转义，避免干扰正则匹配逻辑。
2. 使用正确的单词边界：用\\b标记完整单词的起始和结束位置，确保只匹配整个目标字符串。
3. 全局正则替换：在正则表达式中添加g标志，确保所有符合条件的匹配项都被替换。

修改后的完整代码 #

// 转义正则特殊字符的工具函数
function escapeRegExp(str) {
  return str.replace(/[.*+?^${}()|[\]\\]/g, '\\$&');
}

function test_n() {
let  arr= [
 [ 'Collins, Matthew James'],
 [ 'Collins, Matthew'],
 [ 'Collins, Matthew J'],
 [ 'Collins, M. J.'],
 [ 'Collins, M.J.'],
 [ 'Collins, M.'],
 [ 'Collins, M.J'],
 [ 'Collins, M'],
 [ 'Collins, M J']
]

 let RgX = [
 [ 'Collins, Matthew James', 'Collins, Matthew' ],
 [ 'Collins, Matthew', 'Collins, Matthew' ],
 [ 'Collins, Matthew J', 'Collins, Matthew' ],
 [ 'Collins, M. J.', 'Collins, Matthew' ],
 [ 'Collins, M.J.', 'Collins, Matthew' ],
 [ 'Collins, M.', 'Collins, Matthew' ],
 [ 'Collins, M.J', 'Collins, Matthew' ],
 [ 'Collins, M', 'Collins, Matthew' ],
 [ 'Collins, M J', 'Collins, Matthew' ]
]

arr = processValues(arr, RgX)
console.log(arr)
}


function processValues(values, replaceTable) {
  return values.map(row =>
    row.map(c => c 
     ? replaceTable.reduce(
       (curString, tableEntry) => {
         // 转义目标字符串，构造完整单词匹配的正则
         const escapedTarget = escapeRegExp(tableEntry[0]);
         const regex = new RegExp(`\\b${escapedTarget}\\b`, 'g');
         return curString.replaceAll(regex, tableEntry[1]);
       }
       , c) : '', ""));
}

验证结果 #

运行修改后的代码，输出符合预期：

[ [ 'Collins, Matthew' ],
  [ 'Collins, Matthew' ],
  [ 'Collins, Matthew' ],
  [ 'Collins, Matthew' ],
  [ 'Collins, Matthew' ],
  [ 'Collins, Matthew' ],
  [ 'Collins, Matthew' ],
  [ 'Collins, Matthew' ],
  [ 'Collins, Matthew' ] ]

内容的提问来源于stack exchange，提问作者Einarr