Help with custom column format string to force a comma

[jecilop]

UPDATE: Solved as of Post #5.

ORIGINAL POST:
Umm..I DON'T follow all the info on this stuff but I try. I've tried various combinations but only get text of what I try returned in a custom column.

Column is #words which counts words in the book.
Current formatting is simply integer.

I want it to return the number with a comma to indicate the thousands.

I've looked at the info on Format String Syntax and the format() function.
I can't get any combo I've tried to work. It looks like it should be simple, but it ISN'T HAPPENING. I'm feeling like an idiot over this.

Could someone help with this?
Attached is a picture of the custom column window.

[chaley]

Use

{:,d}

The 'd' is optional, but I like it because it documents what kind of number I think it is, in this case integer.

[jecilop]

Thank you, @chaley.
Tested and working. That was far simpler than anything I was coming up with!

Next hurdle: Do you know a modification I could make to the Save to Disk "save template" that would force this also? I already having it printing the words using {#words:|(|words)} in case none are generated/exist for the type of entry.
I tested it after the comma 'fix', but it definitely isn't based on the appearance in Calibre - just the hard data.

Whoops!!! Turns out doing this affects using that column in a math function. Once the comma format is there, the simple math function (generating a custom page count) stopped working and returned an error.... Arrgh..

I'd still like to know if I can force the comma to show in the save to disk template "tag".
Interestingly, the comma shows in the book metadata jacket as desired when this code is applied. The tags or references are the same so it's curious that one shows commas and not the other.

[chaley]

Originally Posted by jecilop

Next hurdle: Do you know a modification I could make to the Save to Disk "save template" that would force this also? I already having it printing the words using {#words:|(|words)} in case none are generated/exist for the type of entry.
I tested it after the comma 'fix', but it definitely isn't based on the appearance in Calibre - just the hard data.

{#words:,d|| words}

Whoops!!! Turns out doing this affects using that column in a math function. Once the comma format is there, the simple math function (generating a custom page count) stopped working and returned an error.... Arrgh..

use "raw_field(#words)" instead of "field(words)" in the template that is doing the calculation.

Interestingly, the comma shows in the book metadata jacket as desired when this code is applied. The tags or references are the same so it's curious that one shows commas and not the other.

It is arguably a bug that save-to-disk ignores the format spec. However, I am not going to change it because who knows how many templates that would break and the work around is easy.

[jecilop]

Well, that's just clever. .


Tested and working
Thank You
Thank You
and did I mention...THANK YOU!?

[Brajbhushan]

I have a custom column for number of Goodreads ratings. I would like the values to be displayed in comma separated format. I am not able to figure out the template to achieve the same. Here is the image of my column settings:

[Brajbhushan]

Originally Posted by Brajbhushan

I have a custom column for number of Goodreads ratings. I would like the values to be displayed in comma separated format. I am not able to figure out the template to achieve the same. Here is the image of my column settings:

I was able to solve it with following template:
{identifiers:,d:select(grvotes)}