Sorting by number?

ChaoticAdventure · 07-28-2024, 10:15 PM

I am confused about how the sorting works in the tag browser? I have two columns (built from other columns) that I want to sort by number, but they are putting "19" before "2" etc. The setting says "sort by number" in the preferences, but it doesn't seem to do anything different than the "sort by text" option. I feel like I'm missing something really obvious but I cannot figure it out

theducks · 07-28-2024, 10:41 PM

That is a Letter (Alpha) sort effect because your field is Text not Numeric
If you need text, then you mus make all sets of digits the same length(by padding with a leading 0)
02
03
19
20

chaley · Yesterday, 06:46 AM

See Preferences / Behavior / Recognize numbers inside text when sorting.

ChaoticAdventure · Today, 10:20 AM

Quote:

Originally Posted by theducks

That is a Letter (Alpha) sort effect because your field is Text not Numeric
If you need text, then you mus make all sets of digits the same length(by padding with a leading 0)
02
03
19
20

Thank you, that did the trick!! I am learning a lot about computers all the time just by using Calibre. I really appreciate it

chaley: unfortunately that setting did not seem to do anything.

07-28-2024, 10:15 PM	#1
ChaoticAdventure Junior Member Posts: 8 Karma: 10 Join Date: Jan 2024 Device: Kindle Paperwhite, Calibre	Sorting by number? I am confused about how the sorting works in the tag browser? I have two columns (built from other columns) that I want to sort by number, but they are putting "19" before "2" etc. The setting says "sort by number" in the preferences, but it doesn't seem to do anything different than the "sort by text" option. I feel like I'm missing something really obvious but I cannot figure it out

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Issues with decimal numbers sorting + sorting series but showing title first	TheRealAce	Devices	3	12-23-2019 03:53 PM
[Android] number sorting	EdShdBeInBed	Calibre Companion	3	09-28-2017 01:54 AM
Sorting books based on the NUMBER of authors	RotAnal	Library Management	4	02-21-2017 11:00 AM
Aura HD Sorting Shelves by Number of books	speakingtohe	Kobo Reader	13	06-13-2013 02:05 AM
Title Sorting / Author Sorting	ahi	Sony Reader	0	09-14-2009 01:51 PM

07-28-2024, 10:41 PM	#2
theducks Well trained by Cats Posts: 30,138 Karma: 57532198 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	That is a Letter (Alpha) sort effect because your field is Text not Numeric If you need text, then you mus make all sets of digits the same length(by padding with a leading 0) 02 03 19 20

Yesterday, 06:46 AM	#3
chaley Grand Sorcerer Posts: 11,863 Karma: 7036239 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	See Preferences / Behavior / Recognize numbers inside text when sorting.

Advert