Quote:
Originally Posted by mbovenka
I would start with something like (in Edit Metadata (in bulk) -> Search and replace):
Search field: Title
Search for: \(.*\) by \(.*\)
Replace with: \2
Destination field: Author
Note that this will not take any 'by' in the Title into account, so it's very basic.
Assuming this worked, you can do the same with Replace with: \1 and Destination field: Title to update the title.
Again, test whether it does what you want, this is off the top of my head. You will have to fix the author field yourself afterwards (thing like commas instead of & and stuff like that).
|
Thanks for your reply, unfortunately, now I have the whole text string in both the title and the authors fields and need to:
- delete the authors from the title
- delete the title from the authors
oh well, it may still be quicker than simple cut and paste and edit. I'll give it a try with more than 1 title
