how to find books with only one particular format

peaceridge · 04-18-2013, 01:44 PM

I promise I've both googled this and read the manual, but can't figure out how to do it. I have a lot of non-fiction books, some of which have been converted by Calibre to various formats. I do not convert pdf books that have a lot of pictures or use color for any particular reason. I'd like to find all of these so I can put them on my color ereader, but I don't want any that I've already converted to a different format.

I know I start out search with formats:"=PDF" , but how do I add also doesn't have any other format?

Thanks,

theducks · 04-18-2013, 02:19 PM

Code:

not formats:"=DOC" and  not formats:"=EPUB" and  not formats:"=LIT" and  not formats:"=LRF" and  not formats:"=MOBI" and  not formats:"=ODT" and  not formats:"=PDB" and formats:"=PDF" and  not formats:"=PRC" and  not formats:"=RAR" and  not formats:"=RTF" and  not formats:"=TXT" and  not formats:"=ZIP"

works (you can simplify by removing format terms not in your library)

peaceridge · 04-18-2013, 02:23 PM

Quote:

Originally Posted by theducks

Code:

not formats:"=DOC" and  not formats:"=EPUB" and  not formats:"=LIT" and  not formats:"=LRF" and  not formats:"=MOBI" and  not formats:"=ODT" and  not formats:"=PDB" and formats:"=PDF" and  not formats:"=PRC" and  not formats:"=RAR" and  not formats:"=RTF" and  not formats:"=TXT" and  not formats:"=ZIP"

works (you can simplify by removing format terms not in your library)

Thanks so very much - worked perfect after I added and not formats:"=azw3"

Somehow I thought there would be a cleaner way than listing all the formats, but whatever works!

Thanks again.

PeterT · 04-18-2013, 02:54 PM

How about

Code:

formats:#=1 and formats:pdf

peaceridge · 04-18-2013, 03:02 PM

Quote:

Originally Posted by PeterT

How about

Code:

formats:#=1 and formats:pdf

Hi Peter, for my learning purposes could you walk me through this - formats:#= means? and the 1 means? Tried looking it up in Python, but that seems to say anything following # is ignored and obviously that is not the case here.

Thanks, always glad to learn something new about Calibre!

Lyn

PeterT · 04-18-2013, 03:11 PM

This was based on a post from chaley...

Quote:

Originally Posted by chaley

search for "formats:#>1" (no quotes) or for whatever number you want. The hash sign tells calibre to count the number of values instead of looking at the values.

Code:

formats:#

means the count of the values in formats so

Code:

formats:#=1

means books with only one format.

And then

Code:

formats:pdf

means books which are in PDF format, so

Code:

formats:#=1 and formats:pdf

means books with only one format, and that format IS PDF.

peaceridge · 04-18-2013, 03:22 PM

Quote:

Originally Posted by PeterT

This was based on a post from chaley...

Code:

formats:#

means the count of the values in formats so

Code:

formats:#=1

means books with only one format.

And then

Code:

formats:pdf

means books which are in PDF format, so

Code:

formats:#=1 and formats:pdf

means books with only one format, and that format IS PDF.

Tremendous! Thanks ever so much!!

PeterT · 04-18-2013, 03:26 PM

So glad it helped. I *KNEW* I had seen something from him on this, so spent some time searching looking for it. And yes.... it's a far more logical approach than listing all possible formats

theducks · 04-18-2013, 04:34 PM

Quote:

Originally Posted by PeterT

So glad it helped. I *KNEW* I had seen something from him on this, so spent some time searching looking for it. And yes.... it's a far more logical approach than listing all possible formats

I updated my saved search to your more elegant one

04-18-2013, 01:44 PM	#1
peaceridge Wizard Posts: 1,029 Karma: 4407864 Join Date: Feb 2009 Location: North Carolina Device: Kobo Aura1, Nexus7.2, Galaxy Tab A 8.4, Ipad Air & Mini 6	how to find books with only one particular format I promise I've both googled this and read the manual, but can't figure out how to do it. I have a lot of non-fiction books, some of which have been converted by Calibre to various formats. I do not convert pdf books that have a lot of pictures or use color for any particular reason. I'd like to find all of these so I can put them on my color ereader, but I don't want any that I've already converted to a different format. I know I start out search with formats:"=PDF" , but how do I add also doesn't have any other format? Thanks,

04-18-2013, 02:19 PM	#2
theducks Well trained by Cats Posts: 31,270 Karma: 61916422 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Code: not formats:"=DOC" and not formats:"=EPUB" and not formats:"=LIT" and not formats:"=LRF" and not formats:"=MOBI" and not formats:"=ODT" and not formats:"=PDB" and formats:"=PDF" and not formats:"=PRC" and not formats:"=RAR" and not formats:"=RTF" and not formats:"=TXT" and not formats:"=ZIP" works (you can simplify by removing format terms not in your library)

04-18-2013, 02:54 PM	#4
PeterT Grand Sorcerer Posts: 13,703 Karma: 79983758 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	How about Code: formats:#=1 and formats:pdf

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using search/GET BOOKS can I find books I haven't got?	johnwhelan	Calibre	7	06-03-2012 02:53 PM
Find books lacking a specific format	jt421	Calibre	2	06-23-2011 08:05 AM
Can't find books	20LEgend	Library Management	4	02-06-2011 10:05 AM
How to find which book do not have a mobi format	onedot3	Calibre	3	01-10-2011 01:26 PM
How do you find books?	AgentBEATS	Reading Recommendations	38	03-14-2010 05:14 AM

04-18-2013, 03:26 PM	#8
PeterT Grand Sorcerer Posts: 13,703 Karma: 79983758 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	So glad it helped. I KNEW I had seen something from him on this, so spent some time searching looking for it. And yes.... it's a far more logical approach than listing all possible formats