Help with template language

[Pepin33]

I'm trying to make a saving template in Calibre. I want to get an identifier from my books and format it to remove left zeros.

For example, if identifier in a book is 0000123, I want my book be saved as "123".
Identifiers are always 8 digit numbers, filled with zeros (00000001, 0000002, etc).

I'm trying to use this template: {identifiers:select(my_id):G}, but I get an error saying "my_id" is not a number, but a string.

I was looking at templates languages, but I can't find any function to convert a string to an integer. Anybody can help me?

[theducks]

Originally Posted by Pepin33

I'm trying to make a saving template in Calibre. I want to get an identifier from my books and format it to remove left zeros.

For example, if identifier in a book is 0000123, I want my book be saved as "123".
Identifiers are always 8 digit numbers, filled with zeros (00000001, 0000002, etc).

I'm trying to use this template: {identifiers:select(my_id):G}, but I get an error saying "my_id" is not a number, but a string.

I was looking at templates languages, but I can't find any function to convert a string to an integer. Anybody can help me?

I am no way a power user of the template language...But

Identifiers: usually consists of 2 parts (the colon is the separator)
1) whose: amazon:
2) the string

Maybe you want: identifier_in_list(val, id, found_val, not_found_val)

[Pepin33]

Originally Posted by theducks

Identifiers: usually consists of 2 parts (the colon is the separator)
1) whose: amazon:
2) the string

Yes, you're right. That is. But my books have a "custom" identifier to identify every one. And the value for this identifier was generated as {'my_id:':'%08d'%book_id}.

Now, I want to save those books using the identifier, but I want to remove left zeros. And if you're thinking about using book_id instead of my_id, not, that doesn't work, because the books are translated to another library so now my_id is not the same as the book_id...

[theducks]

Originally Posted by Pepin33

Yes, you're right. That is. But my books have a "custom" identifier to identify every one. And the value for this identifier was generated as {'my_id:':'%08d'%book_id}.

Now, I want to save those books using the identifier, but I want to remove left zeros. And if you're thinking about using book_id instead of my_id, not, that doesn't work, because the books are translated to another library so now my_id is not the same as the book_id...

Off the top of my head
use Nested commands (program mode),:
convert the numeric string portion to a (integer)Number, then convert that back to a string. That should lose the leading zeros.

[Pepin33]

Originally Posted by theducks

Off the top of my head
use Nested commands (program mode),:
convert the numeric string portion to a (integer)Number, then convert that back to a string. That should lose the leading zeros.

Yes, but how to do that is what I'm asking for.

I tried with:
program: str(int(template('[[identifiers:select(my_id)]]')))

But this doesn't work, and I can't find any function in template language to convert a string to an integer....

[chaley]

Take a look at the format_number function.

[Pepin33]

Originally Posted by chaley

Take a look at the format_number function.

¡Yes! ¡That was the answer! Works perfectly with:

program:format_number(template('[[identifiers:select(my_id)]]'), '{0:g}')

Thank you very much, chaley (and also theducks).

[chaley]

Originally Posted by Pepin33

¡Yes! ¡That was the answer! Works perfectly with:

program:format_number(template('[[identifiers:select(my_id)]]'), '{0:g}')

Thank you very much, chaley (and also theducks).

The following template will have better performance, something that might matter if you have thousands of books in your library.

program:format_number(select(field('identifiers'), 'my_id'), '{0:d}')

[Pepin33]

Originally Posted by chaley

The following template will have better performance, something that might matter if you have thousands of books in your library.

program:format_number(select(field('identifiers'), 'my_id'), '{0:d}')

Ok, thanks again for your help, chaley.