google-sheets - 有没有办法在电子表格的 'GoogleTranslate()' 函数中跳过翻译中的特定单词？

Question

我正在将 GoogleTranslate() 与表格结合使用，将一些内容翻译成不同的语言。在这些内容中，我们有一些不需要翻译的占位符。例如:

This is a Sample Text added by `{__NAME__}` on `{__DATE__}`

我不需要翻译 {__NAME__} 和 {__DATE__} 等占位符。

如何在翻译过程中跳过这些单词？

Answer 1

=ARRAYFORMULA(QUERY(IFERROR(VLOOKUP(TRANSPOSE(SPLIT(GOOGLETRANSLATE(QUERY(
 REGEXREPLACE(TRANSPOSE(SPLIT(A1, " ")), "\{.*\}", "♦"),, 999^99), "en", "es"), " ")),
 {REGEXREPLACE(TRANSPOSE(SPLIT(A1, " ")), "\{.*\}", "♦"), TRANSPOSE(SPLIT(A1, " "))}, 2, 0),
 TRANSPOSE(SPLIT(GOOGLETRANSLATE(QUERY(REGEXREPLACE(
 TRANSPOSE(SPLIT(A1, " ")), "\{.*\}", "♦"),,999), "en", "es"), " "))),,999^99))