Metadata Plugboard for Series Number Reformatting

[Victorious56]

Hello,
As a new Calibre user I have been struggling a little with formatting metadata when saving to disc, specifically the series number.
I would, if possible, like to reformat a series number of 1.00, 2.00 etc to be 1,2 etc with no decimal places shown if they are zero. A series number of 5.10 would convert to 5.1.

I have set up a Metadata Plugboard for the title of

{series:||, Book }{series_index:4.1f|| - }{title}

which gives me titles of

A Song of Ice and Fire, Book 5.1 - A Dance With Dragons, Part 1 - Dreams and Dust
A Song of Ice and Fire, Book 3.0 - A Storm of Swords

Ideally 'Book 3.0' would be changed to 'Book 3', but after much searching I haven't managed to find out if this is possible.
I'd be grateful if any more knowledgeable user could help me

[chaley]

If none of your series numbers are larger than 5 digits (99999.), then use

{series_index:g}

where the 'g' stands for 'general'.

If you do have very large indices, then use

{series_index:re((\.\d)0,\1)}

to strip off any zero after a decimal point and a digit.

[Victorious56]

Thank you chaley, using your first suggestion worked perfectly
Do you know of an online resource which has a list of these formatting options?
Thank you again!

[DoctorOhh]

Originally Posted by Victorious56

Do you know of an online resource which has a list of these formatting options?

This section of the calibre manual outlines the template language and points you to the Python documentation for advanced formatting options.

[Victorious56]

^ Thanks for those. I did have a quick look previously, but I think I need to spend a bit more time on this. I used to be a Cobol programmer but Python is very different