The first question is why? What are you trying to do? There might be a better way to accomplish whatever that is. For example, if you want to do this because it will be better on your device, metadata plugboards could be a better answer.
Assuming you really want to do this, then there are two ways, both using bulk metadata search replace. Both use regular expression mode. First, back up your library in case something goes wrong. Next, select the books to change, then:
Method 1:
Source field: series
Destination field: title
Search for: (.*)
Replace with: whatever you want to add after the title, with \1 standing in for the series name
Mode: append to field.
Split result: unchecked
Method 2:
Source field: {template}
Template: {title} - {series} (or whatever you want the result to look like)
Destination field: title
Search for: empty
Replace with: empty
Mode: Replace field
In both cases, check the test results to be sure that you are getting the result you wish.
|