How to filter an array of arrays?

by

ECMAScript 6

let filtered = arr.filter(dataRow => dataRow[2] === 'Red');

As noted by @ozeebee, ES6 is currently not supported in Google App Scripts, so you should try the following:

ECMAScript 5

var filtered = arr.filter(function (dataRow) {
  return dataRow[2] === 'Red';
});

In the comments, “classic way” refers to the ES5 method.

Explanation

.filter function takes a single parameter which is a callback to a function that returns true if array entry should remain or false if it should be removed, that’s the filtering. In this case, we should check whether third column of table row equals to Red. The code: return dataRow[2] === 'Red' is equal to:

if (dataRow[2] === 'Red') {
  return true;
} else {
  return false;
}

Because the result of comparison is a boolean.

See also

More Related Contents:

  1. What does the range method getValues() return and setValues() accept?
  2. If value is true in Column A, set Column C one higher
  3. Creating a specific pattern with two-dimensional array in scala
  4. How do you resolve a “The parameters (number[]) don’t match the method signature for SpreadsheetApp.Range.setValues” error
  5. Loop over array dimension in plpgsql
  6. AngularJS custom filter function
  7. Multidimensional array with different lengths
  8. Finding neighbours in a two-dimensional array
  9. Malloc a 2D array in C [duplicate]
  10. GCC: Array type has incomplete element type
  11. Swift 4 JSON Decodable with multidimensional and multitype array
  12. ReDim Preserve to a multi-dimensional array in VB6
  13. Return Multidimensional Array From Function
  14. How do I iterate through each element in an n-dimensional matrix in MATLAB?
  15. A different way to malloc a 2D array?
  16. Excel VBA – How to Redim a 2D array?
  17. Convert Dictionary to Array in swift
  18. Why do we need to specify the column size when passing a 2D array as a parameter?
  19. How do i define a structure in Matlab
  20. How to check if element exists in array with jq
  21. Function pointer arrays in Fortran
  22. Get particular element from mongoDB array [duplicate]
  23. How to merge two arrays in a zipper like fashion in Bash?
  24. How do you create an immutable array in Swift?
  25. Loop a multidimensional array and only print two specific column values per row
  26. Check if all values entered into char array are numerical
  27. Why is 248×248 the maximum bi dimensional array size I can declare?
  28. In a CUDA kernel, how do I store an array in “local thread memory”?
  29. Find elements surrounding an element in an array
  30. How does one sort a multi dimensional array by multiple columns in JavaScript?

Leave a Comment