|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
Using a regex for this should be possible. You just need to use named back references and write one expression to capture The and A, and the other to capture the rest of the title. Then it's trivial to reorder them in the replace expression
|01-28-2013, 10:26 AM||#4|
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Ubuntu Linux, Cybook Opus, Motorola Xoom with Mantano Premium
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|