size in kb column

Rellwood · 03-09-2021, 12:35 AM

how do I make a size column that shows the kb? - I have multiple copies of the same book that is only differentiated by the size and I want to know in kb instead of mb because the files on my computer need to match the files in Calibre so I know which to keep and which to chuck.

Thanks!

jbacelar · 03-09-2021, 03:02 AM

This is the template I use in the custom column for Kbytes:

program:
a=divide(booksize(), 1024);
a=re(a,'(\d+)\.\d+','\1');
a=add(a,1);
format_number(a,'n');

And so I have exactly the same value that the file shows in Windows.

chaley · 03-09-2021, 05:21 AM

Quote:

Originally Posted by jbacelar

This is the template I use in the custom column for Kbytes:

program:
a=divide(booksize(), 1024);
a=re(a,'(\d+)\.\d+','\1');
a=add(a,1);
format_number(a,'n');

And so I have exactly the same value that the file shows in Windows.

Just FYI:

Starting in calibre 4.23 you can write:

Code:

program:
	format_number(add(floor(divide(booksize(), 1024)), 1), 'n')

The 'floor()' function was added in that release.

Starting in the next calibre release (5.13) you can write:

Code:

program:
	format_number(floor(booksize()/1024)+1,'n')

The arithmetic operators will be added in that release.

jbacelar · 03-09-2021, 10:43 AM

Quote:

Originally Posted by chaley

The 'floor()' function was added in that release

Thank you very much, I was not aware of the existence of "floor()".

Rellwood · 03-09-2021, 04:00 PM

Quote:

Originally Posted by chaley

Just FYI:

Starting in calibre 4.23 you can write:

Code:

program:
	format_number(add(floor(divide(booksize(), 1024)), 1), 'n')

The 'floor()' function was added in that release.

Starting in the next calibre release (5.13) you can write:

Code:

program:
	format_number(floor(booksize()/1024)+1,'n')

The arithmetic operators will be added in that release.

I hate to ask, but how do I turn this into a column? I never understood programing in Calibre. I was never able to use the program/coding function.

ownedbycats · 03-09-2021, 05:55 PM

Quote:

Originally Posted by Rellwood

I hate to ask, but how do I turn this into a column? I never understood programing in Calibre. I was never able to use the program/coding function.

03-09-2021, 12:35 AM	#1
Rellwood Library Breeder (She/Her) Posts: 1,301 Karma: 1937893 Join Date: Apr 2015 Location: Fullerton, California Device: Paperwhite 2015 (2), PW 2024 (12 GEN), PW 2023 (11 GEN), Scribe (1st)	size in kb column how do I make a size column that shows the kb? - I have multiple copies of the same book that is only differentiated by the size and I want to know in kb instead of mb because the files on my computer need to match the files in Calibre so I know which to keep and which to chuck. Thanks!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Column for size pictures	Polleke1945	Library Management	2	11-15-2017 05:41 AM
Size column shows exactly what?	unboggling	Library Management	4	11-21-2013 02:44 PM
Column for cover size?	Black Scholes	Library Management	2	11-08-2013 03:07 AM
size column	iomari	Calibre	6	09-30-2011 07:00 AM
Refresh size column	Perkin	Calibre	5	09-10-2010 11:31 AM

03-09-2021, 03:02 AM	#2
jbacelar Interested in the matter Posts: 421 Karma: 426094 Join Date: Dec 2011 Location: Spain, south coast Device: Pocketbook InkPad 3	This is the template I use in the custom column for Kbytes: program: a=divide(booksize(), 1024); a=re(a,'(\d+)\.\d+','\1'); a=add(a,1); format_number(a,'n'); And so I have exactly the same value that the file shows in Windows.