How to find easily books with multiple authors?

wladdy · 04-08-2013, 03:17 PM

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.

theducks · 04-08-2013, 03:28 PM

Quote:

Originally Posted by wladdy

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

speakingtohe · 04-08-2013, 03:38 PM

Quote:

Originally Posted by theducks

& 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

Adoby · 04-08-2013, 07:40 PM

You can search for ampersand in author_sort, there it works as intended. But authors:#>1 is better.

kwhaley · 06-20-2014, 01:32 PM

Perfect! I had the same problem.

You can ignore my tweet then.

Kim Whaley

Quote:

Originally Posted by theducks

& 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

04-08-2013, 03:17 PM	#1
wladdy Enthusiast Posts: 28 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Authors	pdurrant	Calibre	33	12-21-2017 12:37 PM
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

04-08-2013, 07:40 PM	#4
Adoby Handy Elephant Posts: 1,736 Karma: 26785668 Join Date: Dec 2009 Location: Southern Sweden, far out in the quiet woods Device: Thinkpad E595, Ubuntu Mate, Huawei Mediapad 5, Bouye Likebook Plus	You can search for ampersand in author_sort, there it works as intended. But authors:#>1 is better.

Advert

Advert