MobileRead Forums - View Single Post - Variable Search, Replace & Transfer to a new field

chaley · 01-13-2011, 01:02 PM

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.

01-13-2011, 01:02 PM	#6
chaley Grand Sorcerer Posts: 12,476 Karma: 8025702 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	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.