Plugboard template series_index integer output as text

[Thorned Rose]

I am wanting to output titles as something like "Book Title (Series Title Book One)" e.g. "A Hat Full of Sky (Tiffany Aching Book Two)"

I've gotten as far as

{title}{#series:| (| }{#series_index:|Book |)}

but I want the series_index number to be output as a word e.g one, five, eleven, etc.

I found this but I'm fairly new to Calibre's advanced stuff so I can't for the life of me work out how to implement it:
https://stackoverflow.com/a/32640407

TIA!

[theducks]

Originally Posted by Thorned Rose

I am wanting to output titles as something like "Book Title (Series Title Book One)" e.g. "A Hat Full of Sky (Tiffany Aching Book Two)"

I've gotten as far as

{title}{#series:| (| }{#series_index:|Book |)}

but I want the series_index number to be output as a word e.g one, five, eleven, etc.

I found this but I'm fairly new to Calibre's advanced stuff so I can't for the life of me work out how to implement it:
https://stackoverflow.com/a/32640407

TIA!

Worms. Big can of.
You are going to slam into filename length limits, way faster .
what happens with higher number series (volume #)?
one-hundred-twenty-seven

some while back, I saw the code to write out the amount on a chech from the numeric value. it was a few dozen lines as it had to parse numbers like seventeen and not as one seven. It needs to put dashes and 'and' in the proper place.
Not simple

[BetterRed]

Originally Posted by theducks

Worms. Big can of.
You are going to slam into filename length limits, way faster .
what happens with higher number series (volume #)?
one-hundred-twenty-seven

some while back, I saw the code to write out the amount on a chech from the numeric value. it was a few dozen lines as it had to parse numbers like seventeen and not as one seven. It needs to put dashes and 'and' in the proper place.
Not simple

Typically what one does is to put limits on the size of the integer part and the number of decimals the function can handle. So for a tax refund cheque writing function, it might be '1,000,000,000,000' and '2'. In this case I would think '1,000' and '1' would probably suffice.

Just for fun, here's some vaguely relevant Word macros from someone you or DoctorOhh might even know ==>> Spell Out Currency

@Thorned Rose - I suspect one of the programmers can chime with a solution, after the holiday - probably written in python encapsulated in a calibre template - way beyond my tired old brain's pay grade.

BR

[davidfor]

I couldn't resist.

As the Python code was supplied, I used it to create a Template function. This is created on the Template function page of the preferences. The values are:

Function: number_as_words
Argument count: 1
Documentation: number_as_words(val) -- Given a number, return the words for the number.
Program code:

def evaluate(self, formatter, kwargs, mi, locals, val):
    try:
        num=int(val)
    except:
        return val
    d = { 0 : 'zero', 1 : 'one', 2 : 'two', 3 : 'three', 4 : 'four', 5 : 'five',
          6 : 'six', 7 : 'seven', 8 : 'eight', 9 : 'nine', 10 : 'ten',
          11 : 'eleven', 12 : 'twelve', 13 : 'thirteen', 14 : 'fourteen',
          15 : 'fifteen', 16 : 'sixteen', 17 : 'seventeen', 18 : 'eighteen',
          19 : 'nineteen', 20 : 'twenty',
          30 : 'thirty', 40 : 'forty', 50 : 'fifty', 60 : 'sixty',
          70 : 'seventy', 80 : 'eighty', 90 : 'ninety' }
    k = 1000
    m = k * 1000
    b = m * 1000
    t = b * 1000

    if (num < 20):
        return d[num]


    if (num < 100):
        if num % 10 == 0: return d[num]
        else: return d[num // 10 * 10] + '-' + d[num % 10]

    if (num < k):
        if num % 100 == 0: return d[num // 100] + ' hundred'
        else: return d[num // 100] + ' hundred and ' + int_to_en(num % 100)

    if (num < m):
        if num % k == 0: return int_to_en(num // k) + ' thousand'
        else: return int_to_en(num // k) + ' thousand, ' + int_to_en(num % k)

    if (num < b):
        if (num % m) == 0: return int_to_en(num // m) + ' million'
        else: return int_to_en(num // m) + ' million, ' + int_to_en(num % m)

    if (num < t):
        if (num % b) == 0: return int_to_en(num // b) + ' billion'
        else: return int_to_en(num // b) + ' billion, ' + int_to_en(num % b)

    if (num % t == 0): return int_to_en(num // t) + ' trillion'
    else: return int_to_en(num // t) + ' trillion, ' + int_to_en(num % t)

    return val

The program code needs to be copied exactly, including the leading spaces.

To use this, the template is:

{series_index:'number_as_words($)'|Book |}

Or, if you want to capitalise it:

{series_index:'capitalize(number_as_words($))'|Book |}

The code is limited as it only handles integers. If the series index is not an integer, the number will be used.


@theducks: I took this as a request for use in a metadata plugboard, not a file name template.

[theducks]

Originally Posted by davidfor

I couldn't resist.

@theducks: I took this as a request for use in a metadata plugboard, not a file name template.

Probably a good take on the request. Too many years using a simple, filename based' device