08-20-2017, 07:35 AM | #1 |
Enthusiast
Posts: 40
Karma: 10
Join Date: Oct 2012
Location: Lyon [France]
Device: JuliusvonJD
|
how to format author_sort case
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 |
08-20-2017, 09:52 AM | #2 | |
Well trained by Cats
Posts: 29,817
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
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 |
|
08-20-2017, 01:37 PM | #3 |
Grand Sorcerer
Posts: 11,742
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
|
08-20-2017, 01:43 PM | #4 |
Grand Sorcerer
Posts: 6,235
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
After detecting the wrong data, bulk edit and check ""Establish automatically author sort" (or something like that, I have the Spanish calibre interface).
|
08-20-2017, 02:13 PM | #5 |
Enthusiast
Posts: 40
Karma: 10
Join Date: Oct 2012
Location: Lyon [France]
Device: JuliusvonJD
|
|
08-20-2017, 02:21 PM | #6 |
Grand Sorcerer
Posts: 6,235
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
|
08-20-2017, 05:58 PM | #7 |
null operator (he/him)
Posts: 20,583
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
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. Last edited by BetterRed; 08-20-2017 at 06:21 PM. Reason: see Added |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New Column for Author_Sort? | hurricane51 | Library Management | 5 | 01-25-2024 06:24 PM |
{author} gives author_sort in template? | Jellby | Calibre | 2 | 01-21-2013 02:25 PM |
author_sort | Jorge Junior | Library Management | 3 | 11-12-2012 10:20 AM |
Problems with author_sort | Poldi | Calibre | 1 | 10-26-2012 07:31 AM |
What am I missing? (author_sort) | megachirops | Calibre | 12 | 09-06-2010 11:15 AM |