Tag Browser: {title_sort:.1} & case-sensitivity

ownedbycats · 04-06-2021, 06:02 AM

Currently, a {title_sort:.1} column in the tag browser results in a bunch of duplicate entries (A, a) due to case sensitivity.

What would I do to get the same functionality (showing all the letters in the tag browser) without all the duplicates?

ownedbycats · 04-06-2021, 06:08 AM

{title_sort:.1:uppercase()} that works sort of but makes a weird hierarchy thing even though I dont have the column set as hierarchial. Not sure why.

chaley · 04-06-2021, 09:39 AM

Quote:

Originally Posted by ownedbycats

{title_sort:.1:uppercase()} that works sort of but makes a weird hierarchy thing even though I dont have the column set as hierarchial. Not sure why.

Because you have "categorize by first letter" on and didn't tell calibre not to partition this category (Preferences / Look & feel / Tag browser / Categories not to partition)

ownedbycats · 04-06-2021, 04:05 PM

I put it in the no-partition list and it worked.

Weird because according to the number of items I had it should have combined.

EDIT: I tweaked the number and now it is!

ownedbycats · 04-06-2021, 06:09 PM

Another question: If there is punctuation at the beginning of a title (I have a few fanfics that do that), is there a way to make it instead use the first alphanumeric character?

I assume it would be a lot more complex though.

chaley · 04-06-2021, 06:18 PM

Quote:

Originally Posted by ownedbycats

Another question: If there is punctuation at the beginning of a title (I have a few fanfics that do that), is there a way to make it instead use the first alphanumeric character?

I assume it would be a lot more complex though.

Code:

{title_sort:'uppercase(re($, '^\W*(\w).*$','\1'))'}

ownedbycats · 04-06-2021, 06:24 PM

thank you!

04-06-2021, 06:02 AM	#1
ownedbycats Custom User Title Posts: 10,812 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Tag Browser: {title_sort:.1} & case-sensitivity Currently, a {title_sort:.1} column in the tag browser results in a bunch of duplicate entries (A, a) due to case sensitivity. What would I do to get the same functionality (showing all the letters in the tag browser) without all the duplicates? Last edited by ownedbycats; 04-06-2021 at 06:04 AM.

04-06-2021, 06:08 AM	#2
ownedbycats Custom User Title Posts: 10,812 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	{title_sort:.1:uppercase()} that works sort of but makes a weird hierarchy thing even though I dont have the column set as hierarchial. Not sure why. Attached Thumbnails Last edited by ownedbycats; 04-06-2021 at 07:47 AM.

04-06-2021, 04:05 PM	#4
ownedbycats Custom User Title Posts: 10,812 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I put it in the no-partition list and it worked. Weird because according to the number of items I had it should have combined. EDIT: I tweaked the number and now it is! Last edited by ownedbycats; 04-06-2021 at 04:49 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drag & Drop to the Tag browser can go awry	ChrisMillward	Calibre	8	02-05-2021 11:22 AM
Tag browser partitioning & letters	ownedbycats	Library Management	7	10-14-2020 12:13 PM
How to stop Tag Browser, Details and Cover Browser from showing on startup?	stuartro	Calibre	1	08-15-2016 11:53 PM
Tag Browser & Series	oldbwl	Calibre	7	10-06-2010 04:58 PM
Removing Case Sensitivity	Talung	Calibre	7	02-05-2009 01:41 AM

04-06-2021, 06:09 PM	#5
ownedbycats Custom User Title Posts: 10,812 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Another question: If there is punctuation at the beginning of a title (I have a few fanfics that do that), is there a way to make it instead use the first alphanumeric character? I assume it would be a lot more complex though.

04-06-2021, 06:24 PM	#7
ownedbycats Custom User Title Posts: 10,812 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	thank you!

Advert

Advert