Simple Script or EA to filter a CSV file

MQL4 Experts Scripts

Job finished

Execution time 22 hours

Specification

I have a large CSV file that I would like to filter and reduce the data in the file. I am looking for a script or EA that will import a large CSV file and export a smaller CSV file.

The data format looks like this:

 

2015.01.05 11:18:56 1.52592 1.52599 2.51 4.12
2015.01.05 11:18:57 1.52592 1.52599 2.14 4.12
2015.01.05 11:18:57 1.52592 1.52599 2.14 4.12
2015.01.05 11:18:57 1.52592 1.52599 1.76 4.12
2015.01.05 11:19:09 1.52595 1.52602 1.12 4.01
2015.01.05 11:19:09 1.52596 1.52605 1.95 4.57
2015.01.05 11:19:11 1.52595 1.526 1.57 3.75
2015.01.05 11:19:12 1.52595 1.526 1.2 3.82
2015.01.05 11:19:12 1.52595 1.526 1.2 3.82
2015.01.05 11:19:20 1.52594 1.526 1 3.82

 

The filtering criteria is simple: Select the highest  values each minute and remove all the seconds data 

The resulting of the data is  

2015.01.05 11:18:00 1.52592 1.52599 2.51 4.12
2015.01.05 11:19:00 1.52626 1.52629 8.25 7.87

Files:

ZIP
CSV.zip
1.4 Mb

Responded

1
Developer 1
Rating
(20)
Projects
34
76%
Arbitration
0
Overdue
9
26%
Free
2
Developer 2
Rating
(195)
Projects
395
28%
Arbitration
155
20% / 52%
Overdue
112
28%
Free

Project information

Budget
10 USD
Deadline
5 day(s)