|01-27-2013, 01:35 AM||#1|
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.
|01-27-2013, 02:18 AM||#2|
US Navy, Retired
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Even though the titles will still show 'The xxxxx xxxx' and "A xxxx xxxx' they will sort as 'xxxxx xxxx, The' and "xxxx xxxx, A'.
|01-28-2013, 07:49 AM||#3|
Join Date: Feb 2008
Device: Cybook Gen3
|01-28-2013, 10:26 AM||#4|
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Search for: A (.*)
And replace with: \1, A
But it is better to use the tweak described above. The title is what it is, you typically only wish to change the sort order.
Last edited by Adoby; 01-28-2013 at 10:31 AM.
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Title bulk edit match - to remove series info from title||Rob557||Library Management||30||12-09-2014 07:06 AM|
|Bulk title replacements||mumdigau||Recipes||0||07-22-2012 01:34 PM|
|Four Squares Appear at the End of the Title||raczyk||Recipes||7||03-17-2012 10:50 PM|
|Bulk Title Mod Option??||kksdragons||Library Management||1||10-27-2011 11:42 PM|
|Reg ex to move 'by author' from title field||maartencoertjens||Library Management||3||10-20-2011 05:26 PM|