Help needed - how to search for library entries with multiple formats

jecilop · 09-19-2015, 01:27 AM

How can I search my library for all entries that have multiple formats?
Example:

Book 1 has .epub, mobi, and .lit formats
Book 2 has .epub and .mobi
Book 3 has .epub
Book 4 has .azw3 and .pdf

I would want all book entries except 3 to return in this search.

I haven't found a combo of "and" and "or" in format searches to work because including epub in the search automatically includes book 3.

Help is REALLY appreciated. I'm surprised this isn't built into the Find Duplication plug-in or even the Quality Check plug-in. I haven't found anything in the help manual to work or on this site. I tried the search format:>=2, but I think that must only work for numerical like fields such as ratings.
Again, this is for library entries that have multiple formats.

kovidgoyal · 09-19-2015, 01:34 AM

From the manual http://manual.calibre-ebook.com/gui.html#search-sort

You can search for the number of items in multiple-valued fields such as tags. These searches begin with the character #, then use the same syntax as numeric fields. For example, to find all books with more than 4 tags use tags:#>4. To find all books with exactly 10 tags use tags:#=10.

jecilop · 09-19-2015, 01:39 AM

Thank You, @KovidGoyal.

format:#>=2 did it !!!
Boy, does this ever save some time!!

09-19-2015, 01:27 AM	#1
jecilop Addict Posts: 260 Karma: 139980 Join Date: Mar 2014 Device: Android	Help needed - how to search for library entries with multiple formats How can I search my library for all entries that have multiple formats? Example: Book 1 has .epub, mobi, and .lit formats Book 2 has .epub and .mobi Book 3 has .epub Book 4 has .azw3 and .pdf I would want all book entries except 3 to return in this search. I haven't found a combo of "and" and "or" in format searches to work because including epub in the search automatically includes book 3. Help is REALLY appreciated. I'm surprised this isn't built into the Find Duplication plug-in or even the Quality Check plug-in. I haven't found anything in the help manual to work or on this site. I tried the search format:>=2, but I think that must only work for numerical like fields such as ratings. Again, this is for library entries that have multiple formats.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple entries of same file	gemgoa	Library Management	12	08-21-2015 12:00 AM
Multiple entries to Kobo competitions	Witty Username	Kobo Reader	2	04-28-2013 07:19 PM
Calibre formats and duplicate book entries	jgt1942	Calibre	4	03-20-2013 09:55 AM
Multiple book entries in library	rainio	Kobo Reader	6	10-04-2012 03:13 AM
Bug: entries with multiple formats trigger multiple conversions	flinx1	Calibre	12	05-21-2010 06:23 AM

09-19-2015, 01:34 AM	#2
kovidgoyal creator of calibre Posts: 45,251 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	From the manual http://manual.calibre-ebook.com/gui.html#search-sort You can search for the number of items in multiple-valued fields such as tags. These searches begin with the character #, then use the same syntax as numeric fields. For example, to find all books with more than 4 tags use tags:#>4. To find all books with exactly 10 tags use tags:#=10.

09-19-2015, 01:39 AM	#3
jecilop Addict Posts: 260 Karma: 139980 Join Date: Mar 2014 Device: Android	Thank You, @KovidGoyal. format:#>=2 did it !!! Boy, does this ever save some time!!

Advert