Rearranging words in the title

Zifnab · 09-09-2013, 11:36 PM

Sorry if this has been asked before, but I could not find it .....
I have a large library, and I have a lot of books that have the author in the title field and title in the author field. Switching them is no big deal, but before I do that, I want to fix the title.
Basically, for some reason, the first word of the title is at the end, so Dog Day Afternoon is Day Afternoon Dog. I have a lot that end in The or A. I want to take the last word and move it to the front and get rid of the space at the end (or move it after the first word). Every attempt I have tried has gone wrong and I am tearing my hair out by the roots. Is there a simple regex formula that will save me from premature baldness?
Thanks.

kovidgoyal · 09-09-2013, 11:49 PM

Search expression

(.*?),\s+(.*)$

Replace expression

\2 \1

09-09-2013, 11:36 PM	#1
Zifnab Member Posts: 13 Karma: 10 Join Date: Mar 2011 Device: Aluratek	Rearranging words in the title Sorry if this has been asked before, but I could not find it ..... I have a large library, and I have a lot of books that have the author in the title field and title in the author field. Switching them is no big deal, but before I do that, I want to fix the title. Basically, for some reason, the first word of the title is at the end, so Dog Day Afternoon is Day Afternoon Dog. I have a lot that end in The or A. I want to take the last word and move it to the front and get rid of the space at the end (or move it after the first word). Every attempt I have tried has gone wrong and I am tearing my hair out by the roots. Is there a simple regex formula that will save me from premature baldness? Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pubit!/Add Title Previewer shows ellipsis in title bar	schooner1892	General Discussions	0	09-15-2012 08:04 PM
Rearranging order of books stored in Calibre	kapierce65	Calibre	9	06-13-2012 02:16 PM
Words considered as articles for title sort strings	lousignolo	Library Management	6	07-22-2011 06:36 PM
iPad Rearranging books on the iBooks bookshelf	HarryT	Apple Devices	31	12-27-2010 11:16 AM
iPad Rearranging Books in Kindle for Ipad app	Erina	Apple Devices	3	10-05-2010 12:57 PM

09-09-2013, 11:49 PM	#2
kovidgoyal creator of calibre Posts: 45,609 Karma: 28549044 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Search expression (.?),\s+(.)$ Replace expression \2 \1

Advert