how to format author_sort case

[aurigod]

I have a lot of author_sort formatted whole in upper case, I would like it like :
Lastname, Firstname
as if I do in edit_author : Lower case and then Title case.
Is it possible?
thanks

[theducks]

Originally Posted by aurigod

I have a lot of author_sort formatted whole in upper case, I would like it like :
Lastname, Firstname
as if I do in edit_author : Lower case and then Title case.
Is it possible?
thanks

Moderator Notice
Moved to Library Management

Right click on most fields to change case. (as you discovered) All 'upper' needs to be lowered FIRST, then select other Case option.
Unfortunately, Bulk mode MDE does not offer anything other than Title case.


To Flip SELECTED AUTHORS, I recommend the Quality check Plugin (Fix section) I also 'standardize 'author initials

[chaley]

Originally Posted by theducks

Unfortunately, Bulk mode MDE does not offer anything other than Title case.

Bulk MDE Search/Replace offers the case change functions as an "after replace" option.

[Terisa de morgan]

After detecting the wrong data, bulk edit and check ""Establish automatically author sort" (or something like that, I have the Spanish calibre interface).

[aurigod]

Originally Posted by Terisa de morgan

After detecting the wrong data, bulk edit and check ""Establish automatically author sort" (or something like that, I have the Spanish calibre interface).

Right, but this action turn the name in upper case

[Terisa de morgan]

Originally Posted by aurigod

Right, but this action turn the name in upper case

Oh, right, none of my author_sort had that problem, so I haven't seen it.

[BetterRed]

FWIW - before I move books from my Intake library to one of my the 'target' libraries I focus on getting the 'authors' column values as I want them - FN LN, Title(ish) case. I then use the Recalculate all author sort values of Manage Authors.

One has to manually correct author_sort for names containing 'St', 'Garcia', non-hyphenated double barrelled last names, etc. Such corrections won't show up as 'pink' in MDE, so there must be something to indicate the author_sort was manually assigned

Added - my Add Books preferences are set in manner that catches duplicates when books are added, moved etc, which rarely happens because I use the Find library duplicates feature of the Find Duplicates plugin before I move books from the Intake to the target library.