count a specific element in a array

Question

I tried to make a script that takes a row form a sheet full with dates, convert it into an array and count a specific date.

I managed to do all except the "count a specific date" part.

the dates in the array looks like this:

Fri Jan 27 2017 00:00:00 GMT+0100 (MEZ)

The arry:

Fri Jan 27 2017 00:00:00 GMT+0100 (MEZ),Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ),Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ),Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ),Mon Jan 02 2017 00:00:00 GMT+0100 (MEZ),,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

The wanted Output: (for "Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)"

Just write a simple loop that compares the array element and increments a counter. Or use array.filter(d => d == specific_date).length — Barmar
– Barmar, Commented Feb 3, 2017 at 17:07
@Barmar I think this should be tagged arrays? Should I make the edit? — ibrahim mahrir
– ibrahim mahrir, Commented Feb 3, 2017 at 17:08
Post an example of the array and the desired output of that array. — ibrahim mahrir
– ibrahim mahrir, Commented Feb 3, 2017 at 17:10

ibrahim mahrir · Accepted Answer · 2017-02-03 17:28:55Z

1

var array = ["Fri Jan 27 2017 00:00:00 GMT+0100 (MEZ)", "Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)", "Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)", "Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)", "Mon Jan 02 2017 00:00:00 GMT+0100 (MEZ)"];

var dateToCount = "Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)";

var count = array.reduce(function (a, d) {
    return d == dateToCount ? ++a : a;
}, 0);

console.log(count);

Note: If you could have lowercases or other form of dates and want to get those counted as well, then parse the dates like this:

var dateToCount = Date.parse("Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)");
var count = array.reduce(function (a, d) {
    return Date.parse(d) == dateToCount ? ++a : a;
}, 0);

edited Feb 3, 2017 at 17:28

answered Feb 3, 2017 at 17:19

ibrahim mahrir

31.8k5 gold badges50 silver badges78 bronze badges

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

5 Comments

Steffen Bauer Over a year ago

the third line gives me a Syntax error in Google Scripts

ibrahim mahrir Over a year ago

@SteffenBauer It could be that your browser doesn't suppot arrow functions. I updated my answer.

ibrahim mahrir Over a year ago

@SteffenBauer That's not an error related to my answer. My code works. Run it in a browser not in an emulator like in the link you provided! It sais the syntax error is in the console.log not in my code above it.

Steffen Bauer Over a year ago

i think somebody deleted the my "Google Apps Script" Tag for this post -.-

ibrahim mahrir Over a year ago

@SteffenBauer Just change the line console. log(count) to whatever does show count. Logger.log("Count is: " + count) and check your logs for example!

Сергій Горбенко · Accepted Answer · 2017-02-03 20:03:16Z

0

If you have an array of strings like these:

var arr = ["Fri Jan 27 2017 00:00:00 GMT+0100 (MEZ)", 
           "Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)", 
           "Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)", 
           "Wed Jan 11 2017 00:00:00 GMT+0100 (MEZ)", 
           "Mon Jan 02 2017 00:00:00 GMT+0100 (MEZ)"];`

Use 2 strings of code;

var day = new Date(arr[0]);
day = day.getDay() + 1;

Just read docs of Date object:

Date object itself: http://www.w3schools.com/jsref/jsref_obj_date.asp

Date.getDay() method: http://www.w3schools.com/jsref/jsref_getday.asp

edited Feb 3, 2017 at 20:03

answered Feb 3, 2017 at 17:41

Сергій Горбенко

11 silver badge4 bronze badges

1 Comment

Сергій Горбенко Over a year ago

@ppasler, thanx. Fixed

Collectives™ on Stack Overflow

count a specific element in a array

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related