Editing title

seadad9903 · 10-16-2013, 05:38 PM

I have a lot of books that are titled "series name/series number - title". I want to remove all but the title. Using the bulk metadata edit, is there a way to remove a specific number of characters?

theducks · 10-16-2013, 05:54 PM

Quote:

Originally Posted by seadad9903

I have a lot of books that are titled "series name/series number - title". I want to remove all but the title. Using the bulk metadata edit, is there a way to remove a specific number of characters?

Yes

REGEX wild card/class with quantifier

\d{9} selects 9 digits (in a row)
[[:alpha:]]{4} 4 letters

Sabardeyn · 10-16-2013, 06:44 PM

seadad9903,
If you have only added books and corrected/tweaked some of the metadata (mostly correcting errors from adding the books rather than adding any new info), it might be a whole lot easier to start all over again. Sometimes dealing with dozens of minor errors, requiring dozens of regex expressions or hand-editing attempts, becomes very frustrating.

To start all over from scratch, you should create a new, empty database (use Choose library>Switch or create library>Enter a new path>Create new library). Then you could change the input formula under Configure>Import/Export>Adding Books>Regular Expression (field halfway down the dialog) and use the suggested regex from my post in Tyrannosaurus Regex.

Read the message in that post carefully, and know that the " - " (space dash space) between elements is absolutely mandatory. If your filenames follow that format you should be fine. Anything that doesn't follow that exact format will result in input errors like you're already seeing and will need to be corrected. This might, at the very least, reduce the number of errors that need to be corrected by hand.

If you've customized your database or have entered a lot of unique metadata (say, book reviews from dozens of sites, added lots of tags, downloaded lots of covers, etc) then correcting what you've already got is the better choice.

10-16-2013, 05:38 PM	#1
seadad9903 Member Posts: 13 Karma: 10 Join Date: Jan 2013 Device: Kindle PW2, Kindle 3 (MIA), Kindle 4 (kidnapped), Kindle Fire HD	Editing title I have a lot of books that are titled "series name/series number - title". I want to remove all but the title. Using the bulk metadata edit, is there a way to remove a specific number of characters?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Title not changed with Bulk Editing	stormsh	Calibre	6	09-23-2013 09:18 PM
Calibre conversion - Book title Editing	marijohn	Conversion	1	10-29-2012 10:53 PM
Editing author and title meta data	jflatto	Calibre	16	06-24-2010 05:41 PM
Editing Topaz Title/Author - Kindle	GRiker	Calibre	2	03-14-2010 01:58 PM
Editing title/author info on lit files	bones_708	Reading and Management	8	01-31-2008 12:09 PM

10-16-2013, 06:44 PM	#3
Sabardeyn Guru Posts: 644 Karma: 1242364 Join Date: May 2009 Location: The Right Coast Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)	seadad9903, If you have only added books and corrected/tweaked some of the metadata (mostly correcting errors from adding the books rather than adding any new info), it might be a whole lot easier to start all over again. Sometimes dealing with dozens of minor errors, requiring dozens of regex expressions or hand-editing attempts, becomes very frustrating. To start all over from scratch, you should create a new, empty database (use Choose library>Switch or create library>Enter a new path>Create new library). Then you could change the input formula under Configure>Import/Export>Adding Books>Regular Expression (field halfway down the dialog) and use the suggested regex from my post in Tyrannosaurus Regex. Read the message in that post carefully, and know that the " - " (space dash space) between elements is absolutely mandatory. If your filenames follow that format you should be fine. Anything that doesn't follow that exact format will result in input errors like you're already seeing and will need to be corrected. This might, at the very least, reduce the number of errors that need to be corrected by hand. If you've customized your database or have entered a lot of unique metadata (say, book reviews from dozens of sites, added lots of tags, downloaded lots of covers, etc) then correcting what you've already got is the better choice.

Advert