View Single Post
Old 04-27-2011, 06:27 PM   #1
Zifnab
Member
Zifnab began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Mar 2011
Device: Aluratek
Appending from one field to another

Hi,
Still struggling with regex. I have a large number of entries that are from the same author and series but are entered into calibre as follows:
Title: Author author - The Series - ###
Author field: Book title
What I would like to do is copy the book title out of the author field and put it after a : and space at the end of the title field. After that, fixing putting the author into the author field is a piece of cake.
I know I can do a search in the author field for (.*?) to get the full title, but I cannot figure out how to append it to the title field so that it is entered like this:
Author author - The Series - ###: title
Can anyone give me the regex expression to do this? I don't care about clearing out the author field, I just want to copy it to the end of the title field.
Thanks.
Zifnab
Zifnab is offline   Reply With Quote