Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 04-08-2013, 03:17 PM   #1
wladdy
Junior Member
wladdy began at the beginning.
 
Posts: 9
Karma: 10
Join Date: Oct 2010
Device: iPad / Kindle DX
How to find easily books with multiple authors?

Hi,

I need to find in the main interface all books with multiple authors
After reading this article I assumed that I needed to use a regular expression to find all books with "&" in the author field. Unfortunately, the following search return nothing:

author:~\&

I'd very much appreciate if someone could explain what I am doing wrong and point me in the right direction.

On the same topic, I would appreciate advice to find all books with one single author or no author at all.

Thanks in advance. W.
wladdy is offline   Reply With Quote
Old 04-08-2013, 03:28 PM   #2
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,478
Karma: 5567061
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by wladdy View Post
Hi,

I need to find in the main interface all books with multiple authors
After reading this article I assumed that I needed to use a regular expression to find all books with "&" in the author field. Unfortunately, the following search return nothing:

author:~\&

I'd very much appreciate if someone could explain what I am doing wrong and point me in the right direction.

On the same topic, I would appreciate advice to find all books with one single author or no author at all.

Thanks in advance. W.
& is a flag, the real link is (hidden in the DB ) author numbers, which is why it will not work.

Try
authors:#>1

for more info http://manual.calibre-ebook.com/gui....arch-interface
theducks is offline   Reply With Quote
 
Enthusiast
Old 04-08-2013, 03:38 PM   #3
speakingtohe
Wizard
speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.
 
Posts: 4,596
Karma: 25170848
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
Quote:
Originally Posted by theducks View Post
& is a flag, the real link is (hidden in the DB ) author numbers, which is why it will not work.

Try
authors:#>1

for more info http://manual.calibre-ebook.com/gui....arch-interface
That works great.
I have a column with a formula in it which I can delete now.

Helen
speakingtohe is offline   Reply With Quote
Old 04-08-2013, 07:40 PM   #4
Adoby
Handy Elephant
Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.
 
Adoby's Avatar
 
Posts: 1,043
Karma: 3824376
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Ubuntu Linux, Cybook Opus, Motorola Xoom with Mantano Premium
You can search for ampersand in author_sort, there it works as intended. But authors:#>1 is better.
Adoby is offline   Reply With Quote
Old 06-20-2014, 01:32 PM   #5
kwhaley
Junior Member
kwhaley began at the beginning.
 
Posts: 1
Karma: 10
Join Date: Mar 2014
Device: Nook Color
Perfect! I had the same problem.

You can ignore my tweet then.

Kim Whaley

Quote:
Originally Posted by theducks View Post
& is a flag, the real link is (hidden in the DB ) author numbers, which is why it will not work.

Try
authors:#>1

for more info http://manual.calibre-ebook.com/gui....arch-interface
kwhaley is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple authors not shown GeoffR Kobo Reader 7 07-30-2013 08:38 PM
Multiple authors ntome Library Management 2 02-10-2012 05:53 PM
How do you find new authors to read? jbcohen Reading Recommendations 46 01-30-2011 04:03 PM
How to specify multiple authors? dotancohen Calibre 2 01-08-2011 01:33 PM
Multiple Authors pdurrant Calibre 16 02-08-2010 07:41 PM


All times are GMT -4. The time now is 01:28 PM.


MobileRead.com is a privately owned, operated and funded community.