Title Column Sort?

bmcs · 12-20-2020, 01:58 PM

It seem s that titles beginning with "A" and "The" are sorted by the second word. Eg. "A Zebra" at the bottom of the list and "The Abc" at the top.
Is it possible to change this sort order so that: "A Zebra" appears near the end of the titles beginning with "A" and "The Abc" appears in between titles beginning with "S" and "U"?
TIA
Dave

BetterRed · 12-20-2020, 02:08 PM

Click image for larger version

Name: Screenshot 2020-12-21 060613.jpg
Views: 71
Size: 225.6 KB
ID: 184147

Change it to strictly_alphabetic

BR

DNSB · 12-20-2020, 02:35 PM

May I ask why you want to use the article as part of the sort? One place I did some IT work for had a temp who filed documents that way and drove everyone else up the wall while she was there. She could not accept that, as examples, The Hudson's Bay Company(*) was filed under H for Hudson's and The Ministry of Education (Province of British Columbia) was filed under M for Ministry and not under T for The. By the time she left, we had about 50% of our clients filed under The.

* Strictly speaking, The Governor and Company of Adventurers of England Trading into Hudson’s Bay.

bmcs · 12-20-2020, 02:50 PM

Thanks "BetterRed". Obviously I need to look more closly at those tweaks.

bmcs · 12-20-2020, 02:54 PM

Hi David,
I get your point and that is my normal sort arrangement, but I have a big one-off exercise where "strictly_alphabetic" meets my requirements.
Regards
Dave

12-20-2020, 01:58 PM	#1
bmcs Enthusiast Posts: 35 Karma: 10 Join Date: Mar 2013 Device: none	Title Column Sort? It seem s that titles beginning with "A" and "The" are sorted by the second word. Eg. "A Zebra" at the bottom of the list and "The Abc" at the top. Is it possible to change this sort order so that: "A Zebra" appears near the end of the titles beginning with "A" and "The Abc" appears in between titles beginning with "S" and "U"? TIA Dave

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sort by author and then publish date (multi-column sort)?	badbob001	Library Management	7	07-22-2020 06:45 PM
Sort on data+time entered into the column "title"?	nikoski	Calibre Companion	4	07-29-2017 03:51 AM
'Title Sort' & 'Author Sort' Search/Report	Funkybassman	Calibre	3	04-17-2016 12:31 PM
Column Title sort	phlois	Library Management	8	09-23-2013 10:59 AM
Is it possible to sort a custom column like authors or title?	arspr	Library Management	2	03-15-2011 04:44 PM

12-20-2020, 02:08 PM	#2
BetterRed null operator (he/him) Posts: 21,718 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	Change it to strictly_alphabetic BR

12-20-2020, 02:35 PM	#3
DNSB Bibliophagist Posts: 46,155 Karma: 168983734 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos	May I ask why you want to use the article as part of the sort? One place I did some IT work for had a temp who filed documents that way and drove everyone else up the wall while she was there. She could not accept that, as examples, The Hudson's Bay Company() was filed under H for Hudson's and The Ministry of Education (Province of British Columbia) was filed under M for Ministry and not under T for The. By the time she left, we had about 50% of our clients filed under The. Strictly speaking, The Governor and Company of Adventurers of England Trading into Hudson’s Bay.

12-20-2020, 02:50 PM	#4
bmcs Enthusiast Posts: 35 Karma: 10 Join Date: Mar 2013 Device: none	Thanks "BetterRed". Obviously I need to look more closly at those tweaks.

12-20-2020, 02:54 PM	#5
bmcs Enthusiast Posts: 35 Karma: 10 Join Date: Mar 2013 Device: none	Hi David, I get your point and that is my normal sort arrangement, but I have a big one-off exercise where "strictly_alphabetic" meets my requirements. Regards Dave

Advert

Advert