MobileRead Forums - View Single Post

morawcik · 03-11-2012, 10:30 AM

Hi.
In my Calibre library I stored Star Wars eBooks and I have problem. I have column "Timeline" where I set data like:

I need sort it first for text (BBY before ABY) and after sort the numbers like:

But I don't have any idea how I can do this. If I use text type for this colum it give me:

Someone can help me, please?

03-11-2012, 10:30 AM	#1
morawcik Junior Member Posts: 7 Karma: 10 Join Date: Mar 2012 Device: none	"New" sort in text column Hi. In my Calibre library I stored Star Wars eBooks and I have problem. I have column "Timeline" where I set data like: 5000 BBY 3000 BBY 23000 BBY 2400 ABY I need sort it first for text (BBY before ABY) and after sort the numbers like: 23000 BBY 5000 BBY 3000 BBY 2400 ABY But I don't have any idea how I can do this. If I use text type for this colum it give me: 5000 BBY 3000 BBY 2400 ABY 23000 BBY Someone can help me, please?