ExifTool search for files with specific time

[Joxi]

Hi everyone,

here my situation : i have a folder with 50000 Images from the past year for a timelapse of a new building.

But 50000 Images are clearly too much and some of them are dark so i wanted to only pick the pictures that are modified from 15:00-15:05 then i get one or two per day.

I tried it with :

Code Select Expand

exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' . that works but it shows me every modified date.

Then i tried:

Code Select Expand

exiftool -filename -filemodifydate -if \b([15]?[0-9]|2[0-3]):([0-5]\d):([0-5]\d)\b . but it still not works.


My goal is to use ExifTool for copying every file in another folder on a specific time like every file that has modify date 15:00-15:05 and then run FFmpeg and render it to a Video.

I hope i can get some help 

Best Regards
Joxi

[Hayo Baan]

Try this:

Code Select Expand

exiftool -filename -if '$datetimeoriginal =~ / 15:0[0-5]:[0-5][0-9]/' .
This will show you all images taken between 15:00:00 and 15:05:59

[Joxi]

Try this:

Code Select Expand

exiftool -filename -if '$datetimeoriginal =~ / 15:0[0-5]:[0-5][0-9]/' .
This will show you all images taken between 15:00:00 and 15:05:59

Thank you for your quick reply!

I tried it and got this :

Code Select Expand

exiftool -filename -if '$datetimeoriginal =~ / 15:0[0-5]:[0-5][0-9]/' .
    1 directories scanned
46526 files failed condition
    0 image files read


[Hayo Baan]

Are you sure you have images taken between 15:00:00 and 15:05:59?
What does exiftool -filename -datetimeoriginal tell you?

(Oh, and if you're on Windows, change the single quotes to double quotes)

[Joxi]

Are you sure you have images taken between 15:00:00 and 15:05:59?
What does exiftool -filename -datetimeoriginal tell you?

(Oh, and if you're on Windows, change the single quotes to double quotes)

Yes i know it cause the cam took an image every 5 min. for the past year.
With the first command i alredy used > text.txt  and then i search manually for 15:00 and i found some images.

I am using Ubuntu for the ExifTool.

Code Select Expand

exiftool -filename -datetimeoriginal .
======== ./P19031311423910.jpg
File Name                       : P19031311423910.jpg
======== ./P19060411584510.jpg
File Name                       : P19060411584510.jpg
i aborted it directly cause it will print all images out.

[Hayo Baan]

Right, your images don't have a datetimeoriginal, that's why it didn't work. Run exiftool with -s -time:all on one of the files to see if there's another tag that can be used instead.

[Joxi]

Right, your images don't have a datetimeoriginal, that's why it didn't work. Run exiftool with -s -time:all on one of the files to see if there's another tag that can be used instead.

Code Select Expand

exiftool -s -time:all P18092417563810.jpg
FileModifyDate                  : 2018:09:24 08:56:35-07:00
FileAccessDate                  : 2018:09:24 08:56:35-07:00
FileInodeChangeDate             : 2019:06:19 01:08:04-07:00


I want to use FileModifyDate                  : 2018:09:24 08:56:35-07:00 for the date.

[Hayo Baan]

Simply use this then:

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ / 15:0[0-5]:[0-5][0-9]/' .

[Joxi]

Simply use this then:

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ / 15:0[0-5]:[0-5][0-9]/' .

Thank you very much that worked!

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .

Is there a way to format the output with like > output.txt to a list with only the file names are inside like :

Code Select Expand


1.jpg
2.jpg
3.jpg


or copy the files directly with exiftool to another folder after using

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .

[Hayo Baan]

Simply use this then:

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ / 15:0[0-5]:[0-5][0-9]/' .

Thank you very much that worked!

Excellent!

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .

Is there a way to format the output with like > output.txt to a list with only the file names are inside like :

Code Select Expand


1.jpg
2.jpg
3.jpg


Yes, add -T to the command:

Code Select Expand

exiftool -T -filename -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .

or copy the files directly with exiftool to another folder after using

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .

You can use the -o option for that. E.g.:

Code Select Expand

exiftool -o . -directory='TARGET' -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .
For more info, have a look at (a.o.) the renaming examples in the documentation.

[Joxi]

Simply use this then:

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ / 15:0[0-5]:[0-5][0-9]/' .

Thank you very much that worked!

Excellent!

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .

Is there a way to format the output with like > output.txt to a list with only the file names are inside like :

Code Select Expand


1.jpg
2.jpg
3.jpg


Yes, add -T to the command:

Code Select Expand

exiftool -T -filename -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .

or copy the files directly with exiftool to another folder after using

Code Select Expand

exiftool -filename -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .

You can use the -o option for that. E.g.:

Code Select Expand

exiftool -o . -directory='TARGET' -if '$FileModifyDate =~ /15:0[0-5]:[0-5][0-9]/' .
For more info, have a look at (a.o.) the renaming examples in the documentation.

Thank you that worked both very well! Problem solved!