Search duplicates based on shooting date and specific extensions

[eswul62]

I have quite a few files that are named as follows:
DSC0001.arw.jpg
and
DSC0001.jpg

the first one is a processed arw file (often 17-22MB), the 2nd one is the actual jpg that I want to keep, often still 5-6MB.

shooting time/date time taken are the same, file name is also the same

how to search for duplicates where:
the file name is the same
the shooting date time (date time taken) is the same
but extensions are different.

Got as far as :
N:\Photos\Sony\ dupe: ext:arw.jpg|.jpg

Q: but how to add shooting date time?
or maybe this is totally wrong from the start...

2022-01-17_11-53-36.png (45.55 KiB) Viewed 1440 times

[void]

Please try the following search:

N:\Photos\Sony\ regex:^(.*)\.arw\.jpg$ fileexists:\1.jpg

This will list all your arw files, where a jpg exists in the same location without the .arw part.


The following search will list both the jpg and arw.jpg files with a duplicated name:
N:\Photos\Sony\ <regex:^(.*)\.arw\.jpg$ fileexists:\1.jpg> | <regex:^(.*)\.jpg$ fileexists:\1.arw.jpg>

From there you can show the Date Taken Property (right click the result list column header and click Add columns...) and compare.
Note: Right click the Date Taken column header and click Find Date Taken duplicates.



There's no shooting date time property in Everything.
I'm not sure where this property comes from.. it doesn't appear to be apart of the Exif spec.
The Date Taken property is supported.



file-exists: