Manage Title?

[Sabardeyn]

I have two questions with regards to Titles within calibre.

1. When looking at the book list sorted on titles, the display simply ignores Articles of Speach (A, The, etc) but does not alter how the title is displayed (example: The Fly is sorted as "Fly, The" but displayed as "The Fly". Is there a way to have calibre both sort and display in Library fashion ("Fly, The")? Note that I'm not asking to change calibre's file structure, I'm just looking to get the sorting and display to match.
2. If this cannot be done, I can use the Tweak for "strict_alphabetic". However I then have to manually resort all of the book titles. Is there an equivalent to a Manage Title function (similar to Manage Authors) which can be used to correct the entire database at once, rather than a per book manual process?

Thanks for considering my question.

[chaley]

1) You can do this with a custom column made from other columns. The template would be {title_sort}. This workaround does not change the content of the Title column, making it clearly a workaround.

2) Change the tweak, select all books, press E to open bulk metadata edit, check the box at the bottom "Update title sort", and press OK.

[itimpi]

If you enter title in 'library' fashion in the first place then I think you will find that item 1) on your list is satisfied. However the problem I can see is that very few (if any) of the metadata sources return data in this format, so you would need to make sure you have told Calibre to not update the Title field when retrieving metadata.

To change existing entries to this format you can use Calibre's regex search/replace function within the bulk metadata edit function to copy Title_Sort to Title.