JS Filter an array of arrays

Question

I'm trying to filter an array of arrays.

I've searched for an answer on S.O. but all questions I've come accross don't match mine (array of objects or a simple array not nested or not the same format, etc ...)

Once the values are stored in an array they look like this:

[[Paris, One ONE, Boss, Wed Mar 01 00:00:00 GMT+01:00 2017, ], [Paris, Two TWO, Temp, Sat Jul 01 00:00:00 GMT+02:00 2017, ], [Paris, Three THREE, Employee, Sat Sep 01 00:00:00 GMT+02:00 2018, ], [Paris, Four FOUR, Intern, Thu Nov 01 00:00:00 GMT+01:00 2018, ], [Paris, Five FIVE, N.A., Sat Dec 01 00:00:00 GMT+01:00 2018, ], [Paris, Six SIX, Director, Tue Jan 01 00:00:00 GMT+01:00 2019, ], [Paris, Seven SEVEN, Director, Fri Jan 01 00:00:00 GMT+01:00 2016, Sun Jul 01 00:00:00 GMT+02:00 2018], [Paris, Eight EIGHT, Director, Fri Jan 01 00:00:00 GMT+01:00 2016, Sun Oct 01 00:00:00 GMT+02:00 2017], [Paris, Nine NINE, N.A., Thu Nov 01 00:00:00 GMT+01:00 2018, Sat Dec 01 00:00:00 GMT+01:00 2018], [London, Ten TEN, Employee, Fri Jan 01 00:00:00 GMT+01:00 2016, Mon Oct 01 00:00:00 GMT+02:00 2018], [London, Eleven ELEVEN, Intern, Mon Feb 01 00:00:00 GMT+01:00 2016, Mon Jan 01 00:00:00 GMT+01:00 2018], [London, Twelve TWELVE, Employee, Sun May 01 00:00:00 GMT+02:00 2016, Sun Oct 01 00:00:00 GMT+02:00 2017]]

I would like to be able to filter this array of arrays and keep the data linked to one community only, Paris for instance.

How would I do that?

Thanks a lot for your help

When you say keep the data linked to one community only you mean you want to filter so the result has only the Paris rows? — Mark
– Mark, Commented Feb 12, 2019 at 18:24
Please share the code you already have so far and we will help you with it. — chrisg86
– chrisg86, Commented Feb 12, 2019 at 18:26
Possible duplicate of Filtering a two dimensional array in apps script — Wicket
– Wicket, Commented Feb 13, 2019 at 4:44

Shay Moshe · Accepted Answer · 2019-02-13 07:12:14Z

6

you can use Array.filter, somthing like this:

const data = [
['Paris', 'One ONE', 'Boss', 'Wed Mar 01 00:00:00 GMT+01:00 2017' ],
['Paris', 'Two TWO', 'Temp', 'Sat Jul 01 00:00:00 GMT+02:00 2017' ],
['London', 'Three THREE', 'Employee, Sat Sep 01 00:00:00 GMT+02:00 2018' ]];

const result = data.filter(function(item) { return item[0]==='Paris'});
// const result = data.filter(item => item[0]==='Paris'); // ES6
console.log(result);

edited Feb 13, 2019 at 7:12

answered Feb 12, 2019 at 18:28

Shay Moshe

4824 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Wicket Over a year ago

Google Apps Script doesn't support arrow functions

Shay Moshe Over a year ago

@Rubén, OK, see my edit I leave the arrow function in a comment just for general use out of Google Apps, Thanks.

larz · Accepted Answer · 2019-02-13 20:04:30Z

3

Assuming all of the elements in your arrays are Strings, you just check that each array in your array of arrays contains the element Paris.

const yourArray = [
  ['Paris', 'one One', 'whatever else'],
  ['Paris', 'one One', 'whatever else'],
  ['Paris', 'one One', 'whatever else'],
  ['Paris', 'one One', 'whatever else'],
  ['London', 'one One', 'whatever else'],
]

const onlyParis = yourArray.filter(function(array) {
  return array.includes('Paris')
})

console.log(onlyParis)

edited Feb 13, 2019 at 20:04

answered Feb 12, 2019 at 18:26

larz

5,7662 gold badges13 silver badges23 bronze badges

2 Comments

Wicket Over a year ago

Google Apps Script doesn't support arrow functions

larz Over a year ago

@Rubén interesting. Replaced the arrow function.

vmf91 · Accepted Answer · 2019-02-13 04:43:17Z

1

I have converted your array to a JavaScript array. And the filter will be done like this:

var myArray = [['Paris', 'One ONE', 'Boss', 'Wed Mar 01 00:00:00 GMT+01:00 2017'],['Paris', 'Two TWO', 'Temp', 'Sat Jul 01 00:00:00 GMT+02:00 2017'],['Paris', 'Three THREE', 'Employee', 'Sat Sep 01 00:00:00 GMT+02:00 2018'],['Paris', 'Four FOUR', 'Intern', 'Thu Nov 01 00:00:00 GMT+01:00 2018'],['Paris', 'Five FIVE', 'N.A.', 'Sat Dec 01 00:00:00 GMT+01:00 2018'],['Paris', 'Six SIX', 'Director', 'Tue Jan 01 00:00:00 GMT+01:00 2019'],['Paris', 'Seven SEVEN', 'Director', 'Fri Jan 01 00:00:00 GMT+01:00 2016', 'Sun Jul 01 00:00:00 GMT+02:00 2018'],['Paris', 'Eight EIGHT', 'Director', 'Fri Jan 01 00:00:00 GMT+01:00 2016', 'Sun Oct 01 00:00:00 GMT+02:00 2017'],['Paris', 'Nine NINE', 'N.A.', 'Thu Nov 01 00:00:00 GMT+01:00 2018', 'Sat Dec 01 00:00:00 GMT+01:00 2018'],['London', 'Ten TEN', 'Employee', 'Fri Jan 01 00:00:00 GMT+01:00 2016', 'Mon Oct 01 00:00:00 GMT+02:00 2018'],['London', 'Eleven ELEVEN', 'Intern', 'Mon Feb 01 00:00:00 GMT+01:00 2016', 'Mon Jan 01 00:00:00 GMT+01:00 2018'],['London', 'Twelve TWELVE', 'Employee', 'Sun May 01 00:00:00 GMT+02:00 2016', 'Sun Oct 01 00:00:00 GMT+02:00 2017']]

var filteredArray = myArray.filter(function (item){
	return item[0] == 'Paris'
})

console.log(filteredArray)

edited Feb 13, 2019 at 4:43

answered Feb 12, 2019 at 18:29

vmf91

1,94722 silver badges28 bronze badges

4 Comments

Wicket Over a year ago

Google Apps Script doesn't support arrow functions

vmf91 Over a year ago

I have removed the arrow function.

Wicket Over a year ago

Thanks. Maybe you would like to take a look to Filtering a two dimensional array in apps script

vmf91 Over a year ago

Sure. The solution for you is a bit different because I thought you wanted to filter based on the first element which is the city.

Alexei Darmin · Accepted Answer · 2019-02-12 18:27:02Z

0

This function filters the elements of lst which are lists. It compares each list's first element (which is the city name in your example) and returns true if and only if it is equal to 'Paris'.

This makes the implicit assumption that the structure of innerLst does not change. If the city name is moved to a different index, then larz's solution accounts for that.

lst.filter(innerLst => innerLst[0] === 'Paris')

answered Feb 12, 2019 at 18:27

Alexei Darmin

2,1691 gold badge20 silver badges31 bronze badges

2 Comments

Wicket Over a year ago

Google Apps Script doesn't support arrow functions

Alexei Darmin Over a year ago

@Rubén thanks for the heads up, I didn't read the question fully it seems.

Aziz.G · Accepted Answer · 2019-02-12 18:39:19Z

0

const country = [
  ["Paris", "One ONE, Boss, Wed Mar 01 00: 00: 00 GMT + 01: 00 2017", ],
  ["Paris", "Two TWO, Temp, Sat Jul 01 00: 00: 00 GMT + 02: 00 2017", ],
  ["Paris", "Three THREE, Employee, Sat Sep 01 00: 00: 00 GMT + 02: 00 2018", ],
  ["Paris", "Four FOUR, Intern, Thu Nov 01 00: 00: 00 GMT + 01: 00 2018", ],
  ["Paris", "Five FIVE, N.A., Sat Dec 01 00: 00: 00 GMT + 01: 00 2018", ],
  ["Paris, Seven SEVEN, Director, Fri Jan 01 00: 00: 00 GMT + 01: 00 2016, Sun Jul 01 00: 00: 00 GMT + 02: 00 2018"],
  ["London", "Twelve TWELVE, Employee, Sun May 01 00: 00: 00 GMT + 02: 00 2016", "Sun Oct 01 00: 00: 00 GMT + 02: 00 2017"]
]

const res = country.filter(([ville, b, c]) => ville === "Paris")


console.log(res)

edited Feb 12, 2019 at 18:39

answered Feb 12, 2019 at 18:33

Aziz.G

3,7913 gold badges20 silver badges38 bronze badges

3 Comments

Mark Over a year ago

Why all the extra levels of arrays? Why not just call filter on the original array>

Aziz.G Over a year ago

cause i just copy paste his input

Wicket Over a year ago

Google Apps Script doesn't support arrow functions

Collectives™ on Stack Overflow

JS Filter an array of arrays

5 Answers 5

2 Comments

2 Comments

4 Comments

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

2 Comments

4 Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related