• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Collect data of some file on a link folder but no need open

I

IceFrogBG

Member
Hi all,
Once again,I post new thread hope some one can help me.
I have a folder contain many *.csv file (name like "yy-mm-dd.csv")
Purpose I collect data of each file which satisfy yy=17 and mm=07.
example : with "17-07-26.csv" I have to count how many cell of column "A"
is "PASS" and how many is "FAIL". This file is day 26 of July.
So finally result :
Day 1 number of PASS ,number of FAIL
Day 2 number of PASS ,number of FAIL
Day 3 number of PASS ,number of FAIL
....
Day 31 number of PASS ,number of FAIL
similar with other file.
I attach some csv file, please see inside.
I looking for any idea of member on 4rum.
Thanks so much.
 

Attachments

  • New folder.zip
    26.2 KB · Views: 2
my calculate with "17-07-26.csv" there is one cell (A15) is FAIL
and there is one cell (A17) is PASS ,other don't take care.
-> Result Day24 ...
Day25 ...
Day26 1 1
 
You must log in or register to reply here.
Back
Top