Is there a way to output to a CSV file and have the filename field be a relative path and not an absolute one?
I am using a bat file that I drop a folder on to generate the CSV file. This is the code I am currently using:
exiftool -csv -r -D -G -a -exif:Make -exif:model -exif:artist -exif:bitspersample -exif:compression -exif:imageheight -exif:imagewidth -exif:orientation -exif:resolutionunit -exif:software -exif:xresolution -exif:yresolution -iptc:by-line -iptc:source -iptc:jobid -iptc:keywords -XMP:All %1 >> %1\out.csv
This is what appears in the Source Field: I:/2020_035RR_001/objects/cuid12236_015_recto.tif
I would like it to just say /objects/cuid12236_015_recto.tif. So basically it's just the filename and it's immediate parent folder rather than the full path.
CD to I:/2020_035RR_001 and then use a dot for the directory name.
I was able to figure out how to do this with the batch file.
I changed "%1 >> %1\out.csv" to "%~n1 >> %1\out.csv" and now instead of I:/2020_035RR_001/objects/cuid12236_015_recto.tif, I get objects/cuid12236_015_recto.tif as the SourceFile name in the CSV file.