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: 4,686
Karma: 764832
Join Date: Jan 2010
Location: France
Device: PRS-300, Galaxy Nexus, Nexus 7, HTC Sensation, Galaxy Tab 10.1
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