[Solved] How to display, using a filter, only cells that contain Japanese in Google Sheets? [closed]

by


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

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

0

but you could use a script:

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))

0

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), )), "-")

0

solved How to display, using a filter, only cells that contain Japanese in Google Sheets? [closed]