Cleanup Authors

Niall · 09-23-2014, 08:27 AM

Hi All
Excuse me if this is in the wrong place.
I'm trying to cleanup my library and I've found several authors where the value is something like 'Dan - Serial Killer 03 Wells'
I would like to use Edit metadata in bulk to change these to the form 'Dan Wells'.
I got a suitable filter working so I just need to replace the author with first and last words.
Any ideas or do I just have to do it manually?

Cheers
Niall

theducks · 09-23-2014, 10:43 AM

Very Very carefully

BACKUP your ENTIRE LIBRARY as Bulk Metadata edit -S&R is not reversible any other way.

1) There are no 'Something Like's' only EXACTLY''s with/when doing this

Code:

Dan - Serial Killer 03 Wells

.

2) Search: (.+)\s-\s(.+\s\d+\s)(.+)
Replace: \1 \3

\2 is discarded and is used as the delimiter term: First (middle) delimiter Last

PeterT · 09-23-2014, 11:22 AM

Wouldn't it be easier just to select all books by the erroneous author, and then do a manual Bulk Edit and type in the corrected Author name?

theducks · 09-23-2014, 11:33 AM

Quote:

Originally Posted by PeterT

Wouldn't it be easier just to select all books by the erroneous author, and then do a manual Bulk Edit and type in the corrected Author name?

I was assuming the books were imported with a bad horrible template configuration and more than 1 author was involved.

FWIW I have never seen book filed/named that way. Very odd

way of doing things

Niall · 09-23-2014, 01:39 PM

Hi All

Thanks to a prompt from theducks, I figured out what what happened. The problem actually lies with author sort where some of the books were filed LN, FN - Title e.g. 'Wells, Dan - Serial Killer 03'
After importing (i'm not into fixing on import - YET) so I've got rid of the bit after the -
Is there any way of running the set author from author sort on all these files
Cheers
Niall

eschwartz · 09-23-2014, 03:53 PM

Take a look at the Quality Check plugin.

theducks · 09-23-2014, 06:42 PM

The Q C PI has a FIX section that will Flip SELECTED book authors.

The PI has a Metadata check that will FIND those with commas, Then select all and FIX those

Be wary of other uses of Commas in names and deselect those before the FIX

09-23-2014, 08:27 AM	#1
Niall Junior Member Posts: 2 Karma: 10 Join Date: Sep 2014 Device: Kindle	Cleanup Authors Hi All Excuse me if this is in the wrong place. I'm trying to cleanup my library and I've found several authors where the value is something like 'Dan - Serial Killer 03 Wells' I would like to use Edit metadata in bulk to change these to the form 'Dan Wells'. I got a suitable filter working so I just need to replace the author with first and last words. Any ideas or do I just have to do it manually? Cheers Niall

09-23-2014, 10:43 AM	#2
theducks Well trained by Cats Posts: 31,054 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Very Very carefully BACKUP your ENTIRE LIBRARY as Bulk Metadata edit -S&R is not reversible any other way. 1) There are no 'Something Like's' only EXACTLY''s with/when doing this Code: Dan - Serial Killer 03 Wells . 2) Search: (.+)\s-\s(.+\s\d+\s)(.+) Replace: \1 \3 \2 is discarded and is used as the delimiter term: First (middle) delimiter Last

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
automate stylesheet cleanup ?	cybmole	Sigil	9	01-09-2013 06:42 AM
Temp files cleanup	kiwidude	Development	2	03-05-2011 10:56 AM
Any Cleanup tools	theducks	ePub	2	09-10-2010 12:17 PM
Request Application Menu Cleanup	ChrisF	enTourage Archive	7	05-30-2010 02:04 AM

09-23-2014, 11:22 AM	#3
PeterT Grand Sorcerer Posts: 13,511 Karma: 78910202 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	Wouldn't it be easier just to select all books by the erroneous author, and then do a manual Bulk Edit and type in the corrected Author name?

09-23-2014, 01:39 PM	#5
Niall Junior Member Posts: 2 Karma: 10 Join Date: Sep 2014 Device: Kindle	Hi All Thanks to a prompt from theducks, I figured out what what happened. The problem actually lies with author sort where some of the books were filed LN, FN - Title e.g. 'Wells, Dan - Serial Killer 03' After importing (i'm not into fixing on import - YET) so I've got rid of the bit after the - Is there any way of running the set author from author sort on all these files Cheers Niall

09-23-2014, 03:53 PM	#6
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)	Take a look at the Quality Check plugin.

09-23-2014, 06:42 PM	#7
theducks Well trained by Cats Posts: 31,054 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	The Q C PI has a FIX section that will Flip SELECTED book authors. The PI has a Metadata check that will FIND those with commas, Then select all and FIX those Be wary of other uses of Commas in names and deselect those before the FIX

Advert

Advert