help with directory split

[lfcnutter]

i've found the topic on using command to print directory as below

exiftool -p "${directory;s(.*/)()}" "c:/photostore/photos/2011/2011-01" -r

which gets me "2011-01"

I'd like to incorporate the directory split into a csv output  with several other tags.

I've tried to adapt to command but failed.
can anyone help me please?

[greybeard]

How about:

Code Select Expand

exiftool -p "$make,$model,${directory;s(.*/)()}" -r "c:/photostore/photos/2011/2011-01"

[StarGeek]

Splitting the directory like that can't be used with the -csv option, if that was what you were looking to do. You would instead have to create the CSV file using the -n (--printConv) option as greybeard shows.

A problem arises if there are commas in the data. FAQ #12 "How do I export information from exiftool to a database?" gives a way to fix this using the -api Filter option. Look to the end of that FAQ where it says "in a Windows CMD shell/in Mac/Linux"

[greybeard]

I generally use the pipe symbol if there is any chance of commas in the data:

Code Select Expand

exiftool -p "$make|$model|${directory;s(.*/)()}" -r "c:/photostore/photos/2011/2011-01"

[lfcnutter]

thanks both for the speedy and accurate response.
I'm now well on the way to completing my project.