Search for images with specific number of keywords?

[thomaskyhn]

Is it possible to search for images with a specific number of keywords (or more/fewer than a specific number of keywords)?

[Kirk Baker]

No, this is not currently possible.

-Kirk

[thomaskyhn]

Thanks for the info.

Thomas

[Mick O (Camera Bits)]

Oddly, I was just trying to do this myself, and I found that if I exported a spreadsheet of my keywords and filenames, I could use this clever excel formula to count the keywords:
https://exceljet.net/formula/count-total-words-in-a-cell

Make sure to scroll down to the version that accounts for empty cells for images with no keywords.  You could sort the spreadsheet by wordcount and then select the filenames from whatever range you needed and load that back into PM as a selection.  Not something you would want to do dozens of times, but if you only needed to do it once, this might help you?

Mick

[thomaskyhn]

Oddly, I was just trying to do this myself, and I found that if I exported a spreadsheet of my keywords and filenames, I could use this clever excel formula to count the keywords:
https://exceljet.net/formula/count-total-words-in-a-cell

Make sure to scroll down to the version that accounts for empty cells for images with no keywords.  You could sort the spreadsheet by wordcount and then select the filenames from whatever range you needed and load that back into PM as a selection.  Not something you would want to do dozens of times, but if you only needed to do it once, this might help you?

Mick

Thanks for the suggestion. I've tried it but I can't get Excel to accept the formula, I get the "There's a problem with this formula" message, and I can't figure out what's wrong.

Thomas

[Odd Skjaeveland]

I get the "There's a problem with this formula" message, and I can't figure out what's wrong.

Excel formulas tend to break when copied between different locales or languages.

[thomaskyhn]

I get the "There's a problem with this formula" message, and I can't figure out what's wrong.

Excel formulas tend to break when copied between different locales or languages.

Thanks. I wasn't aware of that.

I found a very basic workaround: replacing every individual keyword/string of hierarchical keywords with a single character using search and replace.

[Odd Skjaeveland]

I wasn't aware of that.

The formula uses/calls Excel functions like LEN(), TRIM(), SUBSTITUTE()... In case your Excel is for a non-English language, the functions may have different names. Yes, it is Microsoft wisdom If so, you need to amend the function names used in your formula accordingly. Functions like SUBSTITUTE() and IF() require a list of arguments separated by a list-separator-character. That is typically a comma or a semicolon depending on locale. You may have to replace the list separator.

Your spreadsheet may require the IF(LEN(TRIM(B5))>0,1,0) rather than LEN(TRIM(B5)). My LibreOffice spreadsheet returns boolean True or False rather than 1 or 0 and I need the IF() variant. On my system: IF(LEN(TRIM(B5))>0;1;0).

[thomaskyhn]

I wasn't aware of that.

The formula uses/calls Excel functions like LEN(), TRIM(), SUBSTITUTE()... In case your Excel is for a non-English language, the functions may have different names. Yes, it is Microsoft wisdom If so, you need to amend the function names used in your formula accordingly. Functions like SUBSTITUTE() and IF() require a list of arguments separated by a list-separator-character. That is typically a comma or a semicolon depending on locale. You may have to replace the list separator.

Your spreadsheet may require the IF(LEN(TRIM(B5))>0,1,0) rather than LEN(TRIM(B5)). My LibreOffice spreadsheet returns boolean True or False rather than 1 or 0 and I need the IF() variant. On my system: IF(LEN(TRIM(B5))>0;1;0).

Thanks, I'll give that a try!

I'm not sure if it makes any difference, but I use Excel in English.

[Mick O (Camera Bits)]

Thanks Odd S for chiming in.  I confess to not being that great with Excel --  While that article was written to be used in Excel, I actually used that formula in Google Sheets where it works like a charm.  Sorry I can't be more help in Excel, but I'm glad you are finding a workaround.

Mick