如何使用过滤器仅在Google表格中显示包含日语的单元格? [英] How to display, using a filter, only cells that contain Japanese in Google Sheets?

问题描述

我在自定义公式框中尝试了此公式:

I tried this formula in the custom formula box:

=DETECTLANGUAGE(A:A)=ja

但是它不起作用.所有单元格都被隐藏.我在做什么错了?

But it doesn't work. All cells are hidden. What am I doing wrong?

推荐答案

请注意，DETECTLANGUAGE不适用于数组/范围，因此只能:

note that DETECTLANGUAGE does not work with array/range so only:

=IF(DETECTLANGUAGE(A1)="ja", "Japanese", )

但是您可以使用脚本:

function NIPPON(input) {
     var output = [];
     for (i = 0 ; i < input.length; i++){
    try {
    output[i] = LanguageApp.translate(input[i], '', 'ja');
    }
    catch(err) {
      output[i] = err.message;
      }
      }   return output; }

---

=ARRAYFORMULA(FILTER(A1:A, IF(LEN(A1:A)=LEN(NIPPON(A1:A)), LEN(A1:A), )>0))

在数组中使用DETECTLANGUAGE进行英语检测的示例:

example of using DETECTLANGUAGE in an array for English detection:

=IFERROR(ARRAYFORMULA(IF(LEN(A5:A), 
 IF({DETECTLANGUAGE(A5)="en";
     DETECTLANGUAGE(A6)="en";
     DETECTLANGUAGE(A7)="en";
     DETECTLANGUAGE(A8)="en";
     DETECTLANGUAGE(A9)="en";
     DETECTLANGUAGE(A10)="en"}, 
 LEN(A5:A), 0), )), "-")

这篇关于如何使用过滤器仅在Google表格中显示包含日语的单元格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！