<?php
// your code goes here<?php
//Set Dates
$fromDateTime = new DateTime('Wed, Sep 19 2018 08:00:00');
$toDateTime = new DateTime('Wed, Sep 19 2018 11:00:00');
// Load File
//$file = file_get_contents('/Users/bam/Downloads/test.txt');
$file = 'City Siren FCT_Tester #1 10039273
Date: 160518, Version: 1.00
ID Test Min Max Unit
1 Battery level 2.85 3.40 V
2 Piezo sound level 1.45 2.80 V
3 Left D3 (Ch 3) light intensity 2000 10000 mcd
4 Right D2 (Ch 1) light intensity 2000 10000 mcd
Date Time Battery level Piezo sound level Left D3 (Ch 3) light intensity Right D2 (Ch 1) light intensity
Tue, Sep 18 2018 23:59:53 3.380 1.622 9958.500 7301.000
Wed, Sep 19 2018 00:00:08 3.380 1.622 8817.900 7194.800
Wed, Sep 19 2018 00:00:28 3.343 1.598 9089.500 7033.800
Wed, Sep 19 2018 00:00:45 3.376 1.602 8789.200 7285.200
Wed, Sep 19 2018 00:01:01 3.376 1.629 8406.000 7295.700
Wed, Sep 19 2018 00:01:17 3.378 1.623 8468.100 7382.800
Wed, Sep 19 2018 07:01:36 3.366 1.619 9462.900 7200.600
Wed, Sep 19 2018 07:01:54 3.370 1.622 9389.700 7018.500
Wed, Sep 19 2018 08:02:21 3.375 1.582 9637.100 7347.500
Wed, Sep 19 2018 08:02:36 3.377 1.595 8775.200 7414.700
Wed, Sep 19 2018 08:02:52 3.340 1.585 8955.300 7376.700
Wed, Sep 19 2018 09:03:20 3.263 1.600 8325.900 6694.700
Wed, Sep 19 2018 09:03:37 3.369 1.616 9554.400 7045.700
';
// Split by lines
// counter
$rowsintimespan = 0;
// Do Line-By-Line starting by Line 16 (Array Index 15)
for($i = 11; $i < count($lines); $i++) { // if the file is "Tue, Sep 18<tab>2018<tab>23:59:53<tab>"
$dateobj = DateTime::createFromFormat("???,?M?d??Y?H:i:s+", $lines[$i]);
// check if date is in your Timespan
if($dateobj < $toDateTime && $dateobj > $fromDateTime) {
$rowsintimespan++; // count if in timespan
}
}
// Debug-Output
echo $rowsintimespan;
?>
PD9waHAKCi8vIHlvdXIgY29kZSBnb2VzIGhlcmU8P3BocAoKLy9TZXQgRGF0ZXMKJGZyb21EYXRlVGltZSA9IG5ldyBEYXRlVGltZSgnV2VkLCBTZXAgMTkgIDIwMTggMDg6MDA6MDAnKTsKJHRvRGF0ZVRpbWUgPSBuZXcgRGF0ZVRpbWUoJ1dlZCwgU2VwIDE5ICAyMDE4IDExOjAwOjAwJyk7CgovLyBMb2FkIEZpbGUKLy8kZmlsZSA9IGZpbGVfZ2V0X2NvbnRlbnRzKCcvVXNlcnMvYmFtL0Rvd25sb2Fkcy90ZXN0LnR4dCcpOwokZmlsZSA9ICdDaXR5IFNpcmVuIEZDVF9UZXN0ZXIgIzEgMTAwMzkyNzMKRGF0ZTogMTYwNTE4LCBWZXJzaW9uOiAxLjAwCQkJCQoJCQkJCklECVRlc3QgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAlNaW4JTWF4CVVuaXQKMQlCYXR0ZXJ5IGxldmVsICAgICAgICAgICAgICAgICAgICAgICAJMi44NQkzLjQwCVYKMglQaWV6byBzb3VuZCBsZXZlbCAgICAgICAgICAgICAgICAgICAgICAgCTEuNDUJMi44MAlWCQozCUxlZnQgRDMgIChDaCAzKSBsaWdodCBpbnRlbnNpdHkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCTIwMDAJMTAwMDAJbWNkCjQJUmlnaHQgRDIgIChDaCAxKSBsaWdodCBpbnRlbnNpdHkgICAgICAgICAgICAgICAgICAgICAgICAgIAkyMDAwCTEwMDAwCW1jZAoJCQkJCQpEYXRlCVRpbWUJQmF0dGVyeSBsZXZlbCAgICAgICAgICAgICAgICAgICAgICAgCVBpZXpvIHNvdW5kIGxldmVsICAgICAgICAgICAgICAgICAgICAgICAJTGVmdCBEMyAgKENoIDMpIGxpZ2h0IGludGVuc2l0eSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAJUmlnaHQgRDIgIChDaCAxKSBsaWdodCBpbnRlbnNpdHkgICAgICAgICAgICAgICAgICAgICAgICAgIAoKVHVlLCBTZXAgMTggIDIwMTgJMjM6NTk6NTMJMy4zODAJMS42MjIJOTk1OC41MDAJNzMwMS4wMDAKV2VkLCBTZXAgMTkgIDIwMTgJMDA6MDA6MDgJMy4zODAJMS42MjIJODgxNy45MDAJNzE5NC44MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDA6MDA6MjgJMy4zNDMJMS41OTgJOTA4OS41MDAJNzAzMy44MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDA6MDA6NDUJMy4zNzYJMS42MDIJODc4OS4yMDAJNzI4NS4yMDAKV2VkLCBTZXAgMTkgIDIwMTgJMDA6MDE6MDEJMy4zNzYJMS42MjkJODQwNi4wMDAJNzI5NS43MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDA6MDE6MTcJMy4zNzgJMS42MjMJODQ2OC4xMDAJNzM4Mi44MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDc6MDE6MzYJMy4zNjYJMS42MTkJOTQ2Mi45MDAJNzIwMC42MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDc6MDE6NTQJMy4zNzAJMS42MjIJOTM4OS43MDAJNzAxOC41MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDg6MDI6MjEJMy4zNzUJMS41ODIJOTYzNy4xMDAJNzM0Ny41MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDg6MDI6MzYJMy4zNzcJMS41OTUJODc3NS4yMDAJNzQxNC43MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDg6MDI6NTIJMy4zNDAJMS41ODUJODk1NS4zMDAJNzM3Ni43MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDk6MDM6MjAJMy4yNjMJMS42MDAJODMyNS45MDAJNjY5NC43MDAKV2VkLCBTZXAgMTkgIDIwMTgJMDk6MDM6MzcJMy4zNjkJMS42MTYJOTU1NC40MDAJNzA0NS43MDAKJzsKCi8vIFNwbGl0IGJ5IGxpbmVzCiRsaW5lcyA9IGV4cGxvZGUoIlxuIiwkZmlsZSk7CgovLyBjb3VudGVyCiRyb3dzaW50aW1lc3BhbiA9IDA7CgovLyBEbyBMaW5lLUJ5LUxpbmUgc3RhcnRpbmcgYnkgTGluZSAxNiAoQXJyYXkgSW5kZXggMTUpCmZvcigkaSA9IDExOyAkaSA8IGNvdW50KCRsaW5lcyk7ICRpKyspIHsKICAgIC8vIGlmIHRoZSBmaWxlIGlzICJUdWUsIFNlcCAxODx0YWI+MjAxODx0YWI+MjM6NTk6NTM8dGFiPiIKICAgICRkYXRlb2JqID0gRGF0ZVRpbWU6OmNyZWF0ZUZyb21Gb3JtYXQoIj8/Pyw/TT9kPz9ZP0g6aTpzKyIsICRsaW5lc1skaV0pOwoKICAgIC8vIGNoZWNrIGlmIGRhdGUgaXMgaW4geW91ciBUaW1lc3BhbgogICAgaWYoJGRhdGVvYmogPCAkdG9EYXRlVGltZSAmJiAkZGF0ZW9iaiA+ICRmcm9tRGF0ZVRpbWUpIHsKICAgICAgICAkcm93c2ludGltZXNwYW4rKzsgLy8gY291bnQgaWYgaW4gdGltZXNwYW4KICAgIH0KfQoKLy8gRGVidWctT3V0cHV0CmVjaG8gJHJvd3NpbnRpbWVzcGFuOwoKPz4K