Need to find arrays inside a container array which contains a specific text in its certain position in apps script (preferred) or java script

Question

****I have an array containing other arrays which is as below, my purpose is to find the arrays in it which are containing the string Type 4 Sheets at their 3rd position inside them. Generally speaking, it will be really great if I can get only those arrays inside the bigger array which contains a specific string at nth position****

[[sheets at upper, intermediate and lower, Type 4 Sheets, Sheets, 8.0, 1.5, 5.0, , 3.0, Exact Sized Material # 1],
 [sheets at  back , Type 4 Sheets, Sheets, 8.0, 1.0, 2.5, , 1.0, Exact Sized Material # 2], 
[dfsdfdsfsd, Type 2 Gola, Gola, 5.0, 1.5, 2.5, , 2.0, Exact Sized Material # 3],
 [sheets at vertical divider, Type 1 Gola, Gola, , 1.5, 2.5, , 1.0, Exact Sized Material # 4], 
[sheets at shutters,  , , 2.0, , 2.5, , 4.0, Exact Sized Material # 5], 
[sheets at shutters,  , , 8.0, , , , 12.0, Exact Sized Material # 6], 
[sheets at shutters,  , , 8.0, , , , 8.0, Exact Sized Material # 7], 
[sheets at shutters,  , , 2.5, , , , 8.0, Exact Sized Material # 8], 
[sheets at shutters,  , , 1.5, , , , 8.0, Exact Sized Material # 9], 
[sheets at shutters,  , , 2.5, , , , 8.0, Exact Sized Material # 10], 
[sheets at shutters,  , , 2.5, , , , 4.0, Exact Sized Material # 11], 
[sheets at shutters,  , , 2.0, , , , 32.0, Exact Sized Material # 12], 
[sheets at shutters,  , , 2.5, , , , 32.0, Exact Sized Material # 13]]

Did you check forEach structures? Are you looking for something like array.forEach(function(a) { if (a[2] =="Type 4 Sheets") results.push(a) }); ? Results should have all arrays that contains the given string in the 3rd. position. — SebaGra
– SebaGra, Commented Sep 7, 2018 at 17:58

ashish singh · Accepted Answer · 2018-09-08 07:18:23Z

1

see if this helps

arr.filter(x => x[positionToCheck] === stringToCheck)

based on comments here is transpiled version

arr.filter(function (x) {
  return x[positionToCheck] === stringToCheck;
});

edited Sep 8, 2018 at 7:18

answered Sep 7, 2018 at 17:49

ashish singh

6,9142 gold badges18 silver badges42 bronze badges

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

3 Comments

tehhowch Over a year ago

You'll need to rewrite the arrow functions as standard JS 1.6, as Google Apps Script has only some support for newer JS features. (Array#filter is supported)

Arsalan Ahmad Ishaq Over a year ago

I tried var filtered = exactSizedMaterialsData.filter(x => x[3] === "Type 4 Sheets"); according to the provided solution but I got Syntax error for this line.

tehhowch Over a year ago

@ArsalanAhmadIshaq note that index 3 is position 4 within the array

SebaGra · Accepted Answer · 2018-09-08 13:35:49Z

0

This can be done in javascript by using forEach:

results = [];
outerarray.forEach(function(a) { 
  if (a[2]==="Type 4 Sheets") 
    results.push(a) 
});

a will be each array inside the outerarray

results should have all internal arrays that contains the given string in the 3rd. position.

answered Sep 8, 2018 at 13:35

SebaGra

2,9992 gold badges36 silver badges43 bronze badges

Collectives™ on Stack Overflow

Need to find arrays inside a container array which contains a specific text in its certain position in apps script (preferred) or java script

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related