View Single Post
Old 01-27-2013, 12:35 AM   #1
macnab69
Zealot
macnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toysmacnab69 shares his or her toys
 
Posts: 112
Karma: 5754
Join Date: Jan 2012
Location: South Africa
Device: Kindle 4
Bulk move 'The' and 'A' to end of Title

Because of the way I handled things before using calibre I have a large number of books whose Titles are 'The xxxxx xxxx' and "A xxxx xxxx'.

Is there a way of automating conversion to 'xxxxx xxx, The' and 'xxxx xxxx, A'.

I can use a regex in Search and Replace to remove 'The" and 'A', but there doesn't seem a way to add them to the end.

Without creating a new column with the modified values and hiding the original.
macnab69 is offline   Reply With Quote