Setting "Title" from "Title Sort" in bulk.

alyshadeshae · 09-16-2022, 09:02 AM

Is there a way to set the title from the title sort?

I fried my hard drive and when my backup copies imported the series information was included in the title, as seen below.

I have almost 5,500 books with this issue and I'm really hoping that there is a way to set the title from the title sort.

chaley · 09-16-2022, 09:23 AM

Use Metadata bulk search and replace. Select all the books you want to change, press 'E' to open the bulk metadata editor, click the Search and replace tab, then fill it in as shown by the screen capture.

To help with typing, the Search for field contains "(^.*$)" (no quotes) and the Replace with field contains "\1".

This might take a while because it will rename folders in your library.

Please have your library on a local disk, not a networked device. This is the kind of operation that triggers catastrophic failures on network devices.

alyshadeshae · 09-16-2022, 10:43 AM

Thank you so very much! I tested it on a handful and it worked perfectly, so I'm running it on the rest now!

I'll still have to go in and fix some to put the "the" and other articles at the beginning, but that will be so much more manageable! I hope you have the best possible day!

09-16-2022, 09:02 AM	#1
alyshadeshae Cat Mom Posts: 14 Karma: 10 Join Date: Jan 2013 Location: Louisiana Device: Likebook Mars	Setting "Title" from "Title Sort" in bulk. Is there a way to set the title from the title sort? I fried my hard drive and when my backup copies imported the series information was included in the title, as seen below. I have almost 5,500 books with this issue and I'm really hoping that there is a way to set the title from the title sort. Attached Thumbnails

09-16-2022, 09:23 AM	#2
chaley Grand Sorcerer Posts: 12,032 Karma: 7257323 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Use Metadata bulk search and replace. Select all the books you want to change, press 'E' to open the bulk metadata editor, click the Search and replace tab, then fill it in as shown by the screen capture. To help with typing, the Search for field contains "(^.*$)" (no quotes) and the Replace with field contains "\1". This might take a while because it will rename folders in your library. Please have your library on a local disk, not a networked device. This is the kind of operation that triggers catastrophic failures on network devices. Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Having "title Sort" always matching "title"	Ansem_93	Library Management	3	02-21-2021 06:48 PM
Deducing "Author sort" and "Title sort" through CLI	wladdy	Library Management	8	08-04-2020 06:20 AM
Sort on data+time entered into the column "title"?	nikoski	Calibre Companion	4	07-29-2017 04:51 AM
Use "short" instead of "full" title for title sort & renaming?	wolpi	Library Management	2	08-04-2016 06:25 PM
A warning for Linux users: slow "Add Books", "Unknown" title and Author	rolgiati	Library Management	8	07-24-2013 05:36 PM

09-16-2022, 10:43 AM	#3
alyshadeshae Cat Mom Posts: 14 Karma: 10 Join Date: Jan 2013 Location: Louisiana Device: Likebook Mars	Thank you so very much! I tested it on a handful and it worked perfectly, so I'm running it on the rest now! I'll still have to go in and fix some to put the "the" and other articles at the beginning, but that will be so much more manageable! I hope you have the best possible day!