Data Mining My Images

[imagething]

I wanted to run this past the experts ...

Exiftool is pretty robust so I'm guessing it might be possible to set a search conditional or parameter when parsing directories.
lets say I wanted to know the filename and date of all the images with keyword Germany.

I started working it out how to create the the .txt and .csv but I need help pulling it all together.

txt doc
-r -w txt -S3 -filename -datetimeoriginal -w+ %d/Germany.txt

I need to be able to create a basic spreadsheet and to also update the metadata if needed.

.csv
-r -filename -csv -f FILE > Germany.csv

Output to parent directory is fine and I also need to prevent duplicate tags.

I'm hoping to set everything up so it can be quickly updated with find & replace command e.g.  find Germany replace w Holland.

Thanks in advance for your help,

Michael

[Alan Clifford]

Searching for Barbados here

Code Select Expand

exiftool -if '$keywords =~ /barbados/i' -keywords -filename -datetimeoriginal -ext jpg .
======== ./dscf2186_2.jpg
Keywords                        : Barbados, scuba, Stavronikita
File Name                       : dscf2186_2.jpg
Date/Time Original              : 2013:01:30 10:51:12
======== ./dscf3678_cr.jpg
Keywords                        : Barbados, Joe's River
File Name                       : dscf3678_cr.jpg
Date/Time Original              : 2011:11:06 14:03:06
======== ./f500_0469_bcr.jpg
Keywords                        : Barbados, Rockley
File Name                       : f500_0469_bcr.jpg
Date/Time Original              : 2012:11:08 11:37:40
    1 directories scanned
   60 files failed condition
    3 image files read

Have a look in the documentation under "-if EXPR" - the search is actually an example there.