Quote:
Originally Posted by ian-and-penny
Is it possible to convert book titles (downloaded from Amazon) that contain series data to contain the title only, and populate the series field with the series info?
For example I would like the book title "Wired In (Paradise Crime Book 1)" to be "Wired in Paradise" and the series column to be populated with "Paradise Crime [1]"
|
Look at the Bulk mode (for 2 or more books) of the Metadata Editor's Search and Replace Tab.
It will take 2+ passes: (I never got series +series_index to work in a single pass)
1) Copies the Series info to the Series Column
I crop out the 'Book'
2) clean up the title (discard the original series stuff)
something like this search title REGEX
Be sure to
backup your Library. Bulk mode has
no UNDO
Search Title
Code:
(.+?)\s\((.+?) Book (\d+)\)
Replaces:
Series: \2
series_index: \3
Title: \1
A couple of other crops/edits I regularly do:
I also crop:
'Series'
'A'
Plurals: Mysteries -> Mystery (this is just one book of many
)