Bulk Edit Title

[tarisea]

Can someone explain in small words how to fix the title of added books coming in as

Title (Series Info) or sometimes Title (Series Info) (Publisher)

I would love to put Series Info into the Series column but I will settle for dumping everything after the first ( into a customer column.

Small words. All the programing and expressions go right over my head. Thank you very much

[DaltonST]

• Auto-Add Books: Automatic JS Quality Fixes and Auto-Run Several Quality-Related Jobs
  
• Apply JS Quality Fixes and Auto-Run Several Quality-Related Jobs for User-Selected Books

No guarantees, but see the attached. The "landscape" image has example titles on its right side.


https://www.mobileread.com/forums/sh...d.php?t=269911



DaltonST

[davidfor]

Originally Posted by tarisea

Can someone explain in small words how to fix the title of added books coming in as

Title (Series Info) or sometimes Title (Series Info) (Publisher)

I would love to put Series Info into the Series column but I will settle for dumping everything after the first ( into a customer column.

Small words. All the programing and expressions go right over my head. Thank you very much

How the metadata is read for a book being added to calibre is set on the "Adding books" page of the preferences. There are two main options. The first is whether to read the metadata from the metadata inside the book. This is my preferred option as more and more books have reasonable metadata.

The next is the regex used to get the metadata from the file name. This is used if the above option is turned off, or the book doesn't contain metadata. From what you are saying, you probably have a simple regex such as:

(?P<title>.+) - (?P<author>[^_]+)

That would put everything before a dash into the title, and everything after it into the author. There should be a few examples on the Adding books page, but exactly what you need depends on the file names being used. For example, if I take the first example as exactly what you see in the title, then the file name probably looked something like:

title (series info) - author

Skin Game (The Dresden Files 15) - Jim Butcher

If that is correct, then the following should work:

(?P<title>[^_].+) ?\s*\((?P<series>[^_0-9-]*)(?P<series_index>[0-9]*)\)\s*-\s*(?P<author>[^_-]+) ?

That shouldn't be hard to expand to include the publisher, or different delimiters around the series info. But, suggesting more, I would need to know more about the file names you are seeing.