View Single Post
Old 01-13-2011, 01:02 PM   #6
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,459
Karma: 831552
Join Date: Jan 2010
Location: France
Device: Many android devices
Fortunately, all of these are single author, so you can avoid templates.

You must do this in three steps, one to move series, one to move title, and one to clean author.

1. Series.
source: author
search: .*- (.*)(\d) -.*
replace: \1 [\2]
dest: series

2. Title
source:authors
search: .*- (.*?)
replace: \1
dest: title

3: authors
source:authors
search:(.*?) - .*
replace: \1
dest: authors

I strongly advise that you check the test windows carefully before letting any of these hammer your db. You might want to make a backup of your library.
chaley is offline   Reply With Quote