Thread: How can I sort a column so 'empty' fields are last?
View Single Post
Old 02-06-2017, 10:27 PM   #1
capnm
Groupie
capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'capnm knows the difference between 'who' and 'whom'
 
Posts: 156
Karma: 10001
Join Date: Feb 2011
Device: sony
How can I sort a column so 'empty' fields are last?
I'd like to be able to sort a custom column so I see the entries in ascending alpha-numeric order with the blank entries last.

It's a column created from other columns via template programming, so I can put whatever value I want in the 'blank' entries.

The obvious solution would be to use a whitespace character that sorts past 'z' in the sorting sequence, but I don't know if there is such a character. (Actually I haven't been able to figure out precisely what collation sequences Calibre uses.)

I'd even settle for a nearly invisible character if that's the best I can do.

Thoughts anyone?

p.s. I'm on Windows 10, which may or may not make a difference.
Last edited by capnm; 02-06-2017 at 11:32 PM.
capnm is offline   Reply With Quote