Export count of Subject items/keywords?

[justmike]

Is it possible to create a counted/calculated column when exporting to a CSV? What I would like is a count of the keywords. I can do it in excel, but I am always in favor of knocking a step out.

[StarGeek]

See this thread.

[justmike]

See this thread.

Thanks—when I ran that, I got:

Code Select Expand

${keywords;$_=()=$self->GetValue('Keywords')}: bad substitution

[Phil Harvey]

If you are on Mac/Linux you need to change the quotes around 'Keywords' to double quotes, then put single quotes around the whole argument.

- Phil

[StarGeek]

If you're using the -csv export option, you might want to use the user-defined tag in that thread.  If you don't already have a .exiftool_config file, grab the example config file, rename it according to the instructions in the file, and copy the text of the KeywordCount tag, find the lines where it says
# Composite tags are added to the Composite table:
    'Image::ExifTool::Composite' => {
and insert it on a new line right after that so it looks like

Code Select Expand

# Composite tags are added to the Composite table:
    'Image::ExifTool::Composite' => {
    KeywordCount => {
        Require => 'Keywords',
        ValueConv => q{
            my @list = ref $val ? @$val : ($val);
            return scalar @list;
        },
    },

You can then use KeywordCount as a tag in your command.