Format words count 1500 as 1.5k

[Courge]

Hello,

I created a custom column "Words" that I fill with the FanFicFare plugin (collecting the number of words from the fanfiction website). Is there a method to format the numbers in kilo? For example, 1500 as 1.5k or 34267 as 34.3k.

I noticed that python format can be used to format custom column but it does not allow python function which would be needed for what I want (see the page https://www.geeksforgeeks.org/python-numerize-library/).

Thank you!

[chaley]

Originally Posted by Courge

Hello,

I created a custom column "Words" that I fill with the FanFicFare plugin (collecting the number of words from the fanfiction website). Is there a method to format the numbers in kilo? For example, 1500 as 1.5k or 34267 as 34.3k.

I noticed that python format can be used to format custom column but it does not allow python function which would be needed for what I want (see the page https://www.geeksforgeeks.org/python-numerize-library/).

Thank you!

You can't do what you want with the format option on the integer custom column. You can do what you want using a composite column (column built from other columns) with a template that computes what you want to see. You would hide the column filled in by FanFicFare and display the composite.

As for formatting the result in the composite, you have the option of using the human_readable() function or doing the arithmetic yourself.

[Courge]

Originally Posted by chaley

You can do what you want using a composite column (column built from other columns) with a template that computes what you want to see. You would hide the column filled in by FanFicFare and display the composite.

As for formatting the result in the composite, you have the option of using the human_readable() function or doing the arithmetic yourself.

Thank you for your answer. I am begining with Calibre and I am not sure how to apply your suggestion. I created a composite column "formated_words" and in "Template" I entered :

human_readable(words)

It simply prints "human_readable(words)" in my new composite column (with "words" the lookup name of my previous column. Do you know what is wrong with my template or where I can find more information?

Thank you!

[BetterRed]

@Courge - When referring to custom columns in a template etc you need to prefix the lookup_name with a hash - eg. #words

BR

[chaley]

Originally Posted by Courge

Thank you for your answer. I am begining with Calibre and I am not sure how to apply your suggestion. I created a composite column "formated_words" and in "Template" I entered :

human_readable(words)

It simply prints "human_readable(words)" in my new composite column (with "words" the lookup name of my previous column. Do you know what is wrong with my template or where I can find more information?

Thank you!

First: as for where you can find more information, see The calibre template language.

My guess is that you want something like this Single Function Mode template

{#words:human_readable()}

If you want more complicated formatting then you will probably should use a General Program Mode template

[Courge]

Thanks to both of you for your answers. I got what I want writing the following template:

program:
before = round($$#words/1000);
after = round(($$#words-(before*1000))/100)*0.1;
complete=before+after

I will add the "k" after the number in the plugboard when sending the files to the device.

[BetterRed]

I initially interpreted your request as wanting 1024 words to be 1K words. I decided against asking why you'd wanna do that.

BR

[davidfor]

Originally Posted by BetterRed

I initially interpreted your request as wanting 1024 words to be 1K words. I decided against asking why you'd wanna do that.

I'm generally against capital punishment, but for the person who thought, "Kilo=1000, 1024 is close enough", I'm willing to make an exception.