javascript - 如何过滤数组内的字符串位置？

Question

我希望按在行的位置 3 上找到的月份和年份过滤数组其中日期为dd/mm/yyy。

从谷歌表格生成的数组:

[[1, 134, DIOGO, 03/12/2019, ggggg, 2], [2, 131, ALEISIO, 13/11/2019, ggg, 33], [3, 134, DIOGO, 25/11/2019, gggg, 2], [4, 134, DIOGO, 15/12/2019, tttttt, 2]]

var funcionarioId ="user1"
var month = "11"
var year = "2019";

var dataFiltered = data.filter(function(item){return item[1] === funcionarioId && 
item[3] === month && 
item[3] === year });

预期结果应该是:

[[2, 131, ALEISIO, 13/11/2019, ggg, 33], [3, 134, DIOGO, 25/11/2019, gggg, 2]]

Answer 1

以下是获取所需数据的代码:

var funcionarioId = '134';
var month = "11"
var year = "2019";

var filteredData = data.filter(function(item) {
var items = item[3].split('/');
return items[1] === month &&
       items[2] === year &&
       item[1] == funcionarioId
});