Matching title and Author

Graham Hurst · 10-20-2014, 04:32 PM

Is there a quick way of searching for books in my library where for example the Author field is the same as the Title field ?

theducks · 10-20-2014, 05:34 PM

Quote:

Originally Posted by Graham Hurst

Is there a quick way of searching for books in my library where for example the Author field is the same as the Title field ?

title:<the name> and authors:<the name>

should work if you know 'the name'

but I suspect you will need to resort to SQL using something like SQLspy

Graham Hurst · 10-20-2014, 06:36 PM

thank for that but unfortunately my question was badly posed I don't know what the <the name> part of the problem is. I frequently find books in my library where the title and author have the same value but can't predict what it will be I was hoping there was a search where matching author and title would get filtered

theducks · 10-20-2014, 07:57 PM

Quote:

Originally Posted by Graham Hurst

thank for that but unfortunately my question was badly posed I don't know what the <the name> part of the problem is. I frequently find books in my library where the title and author have the same value but can't predict what it will be I was hoping there was a search where matching author and title would get filtered

I figured that would be your problem.

eschwartz · 10-20-2014, 08:07 PM

Sounds like something the Quality Check plugin might want to incorporate.

BetterRed · 10-20-2014, 08:15 PM

Quote:

Originally Posted by eschwartz

Sounds like something the Quality Check plugin might want to incorporate.

Or Find Duplicates, or both

BR

theducks · 10-20-2014, 08:59 PM

Usually a Title in the Authors section of the Tag Browser sticks out like a sore thumb.

If you set the Tag Browser to view by 'Popularity', those 'Singles will be even closer together.

That leaves 'Authors' in the 'Title' field

BTW where are this cr*p metadata coming from?

LadyKate · 10-28-2014, 12:07 AM

I've noticed that a fairly large number of books have the author name downloaded as the name of book. A lot of these seem to be ones that include goodreads as a choice. Not sure where exactly these are coming from though. I would put it as one in twenty or so over the last month or so.

If you are allowing metadata downloads to change title and author it pays to double check to ensure they have not changed to something you don't want.

DaltonST · 11-11-2014, 10:04 AM

@Graham Hurst:

You might want to install the add-on/plug-in QuarantineAndScrub. Misplaced and Malformed metadata is exactly what it is designed to fix. It saves an enormous amount of time. Among many other tools, it comes with over 16K Authors already in its database to aid it in parsing out the wheat from the chaff.

https://www.mobileread.com/forums/sho...d.php?t=247425

Also download the .jar file that is really a .zip file, and follow the detailed instructions in the User Instructions.

DaltonST

LadyKate · 11-15-2014, 01:46 PM

Quote:

Originally Posted by DaltonST

@Graham Hurst:

You might want to install the add-on/plug-in QuarantineAndScrub. Misplaced and Malformed metadata is exactly what it is designed to fix. It saves an enormous amount of time. Among many other tools, it comes with over 16K Authors already in its database to aid it in parsing out the wheat from the chaff.

https://www.mobileread.com/forums/sho...d.php?t=247425

Also download the .jar file that is really a .zip file, and follow the detailed instructions in the User Instructions.

DaltonST

Thank you. I'm going to take a look at it. I don't do bulk metadata downloads as I'm anal and want to look at each one I update to put in only the tags I want to use.

10-20-2014, 04:32 PM	#1
Graham Hurst Member Posts: 14 Karma: 10 Join Date: Sep 2014 Location: UK Device: Kobo Aura, Kindle Paperwhite Signature Edition	Matching title and Author Is there a quick way of searching for books in my library where for example the Author field is the same as the Title field ?

11-11-2014, 10:04 AM	#9
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	QuarantineAndScrub Add-On/Plug-In @Graham Hurst: You might want to install the add-on/plug-in QuarantineAndScrub. Misplaced and Malformed metadata is exactly what it is designed to fix. It saves an enormous amount of time. Among many other tools, it comes with over 16K Authors already in its database to aid it in parsing out the wheat from the chaff. https://www.mobileread.com/forums/sho...d.php?t=247425 Also download the .jar file that is really a .zip file, and follow the detailed instructions in the User Instructions. DaltonST

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing from Title-Author to Author - Title	Amalthia	Calibre	17	01-22-2017 11:20 PM
Sort by author then title	richardwarriner	Library Management	3	11-16-2011 01:00 PM
Sort by author AND title	bookends	Calibre	2	05-09-2010 01:55 PM
libprs500 - title/author matching regex	Megatron-UK	Calibre	15	04-01-2008 04:39 PM
how to embed title and author	gteague	Amazon Kindle	3	11-26-2007 09:45 AM

10-20-2014, 06:36 PM	#3
Graham Hurst Member Posts: 14 Karma: 10 Join Date: Sep 2014 Location: UK Device: Kobo Aura, Kindle Paperwhite Signature Edition	thank for that but unfortunately my question was badly posed I don't know what the <the name> part of the problem is. I frequently find books in my library where the title and author have the same value but can't predict what it will be I was hoping there was a search where matching author and title would get filtered

10-20-2014, 08:07 PM	#5
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Sounds like something the Quality Check plugin might want to incorporate.

10-20-2014, 08:59 PM	#7
theducks Well trained by Cats Posts: 30,898 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Usually a Title in the Authors section of the Tag Browser sticks out like a sore thumb. If you set the Tag Browser to view by 'Popularity', those 'Singles will be even closer together. That leaves 'Authors' in the 'Title' field BTW where are this cr*p metadata coming from?

10-28-2014, 12:07 AM	#8
LadyKate Fanatic Posts: 515 Karma: 1470724 Join Date: Jul 2013 Location: Quebec CA Device: android 4 (samsung tablet and asus tablet)	I've noticed that a fairly large number of books have the author name downloaded as the name of book. A lot of these seem to be ones that include goodreads as a choice. Not sure where exactly these are coming from though. I would put it as one in twenty or so over the last month or so. If you are allowing metadata downloads to change title and author it pays to double check to ensure they have not changed to something you don't want.

Advert

Advert