Plugboard, template, and custom composite column recipes

[qqukdbx]

Hi, is there any regex guru who can help me to understand plugboard template "Show author name as Initial and Surname (Kindle) (inspired by brewjono)"? Im afraid i dont fully understand the syntax:

{author_sort:re(\, (.).*?( &|$),\, \1\2)}

When input from author_sort is for example "Goyal, Kovid" regex above produces "K Goyal".
How the regex matches the string and how replaces the field?

[chaley]

Originally Posted by qqukdbx

Hi, is there any regex guru who can help me to understand plugboard template "Show author name as Initial and Surname (Kindle) (inspired by brewjono)"? Im afraid i dont fully understand the syntax:

{author_sort:re(\, (.).*?( &|$),\, \1\2)}

When input from author_sort is for example "Goyal, Kovid" regex above produces "K Goyal".
How the regex matches the string and how replaces the field?

As shown by the attached screenshot, it doesn't produce "K Goyal" but instead produces "Goyal, K", which is what I would expect from the regex.

Where are you seeing the result you say you get? If it is on a device then the device is changing it. Nothing the plugboard can do about that. Workarounds might be available but you should ask in the devices forum, naming your device.

[dunhill]

Hello people
I have this configuration to save to disk.
{title} ({#id}) - {authors}
But the ID comes out with decimals, how could I fix it so that it is a whole number
example:
Title (10017301.0) - author.epub

[chaley]

Originally Posted by dunhill

Hello people
I have this configuration to save to disk.
{title} ({#id}) - {authors}
But the ID comes out with decimals, how could I fix it so that it is a whole number
example:
Title (10017301.0) - author.epub

What kind of column is #id? If it is a "column built from other columns" then what is its template?

My guess is that {title} ({id}) - {authors} will work.

[dunhill]

Originally Posted by chaley

What kind of column is #id? If it is a "column built from other columns" then what is its template?

My guess is that {title} ({id}) - {authors} will work.

It is a custom column, because the id is a personal number, not a calibre number.
For that reason #



My mistake, for not seeing.
Sorry

[chaley]

Originally Posted by dunhill

It is a custom column, because the id is a personal number, not a calibre number.
For that reason #

It is probably a float-type column, which is why it has the decimal point. It seems that it should be an int-type column.

[chaley]

Originally Posted by dunhill

Hello people
I have this configuration to save to disk.
{title} ({#id}) - {authors}
But the ID comes out with decimals, how could I fix it so that it is a whole number

Try

{title} ({#id:15.15g}) - {authors}

The 15 is arbitrary. It must be larger than the maximum number of digits in any #id.

[dunhill]

Originally Posted by chaley

Try

{title} ({#id:15.15g}) - {authors}

The 15 is arbitrary. It must be larger than the maximum number of digits in any #id.

Great !! Now it works, thank you very much

[dunhill]

I have a question about the id.
Let's suppose that I have an id that by order is added 100000000
Example:
Original id 043579 + added 100043579
Question by means of a disk saving template could I get back the original id or a personal column by means of program: ?
Example:
id 100043579 - added 100000000 = id Original 043579

[chaley]

Originally Posted by dunhill

I have a question about the id.
Let's suppose that I have an id that by order is added 100000000
Example:
Original id 043579 + added 100043579
Question by means of a disk saving template could I get back the original id or a personal column by means of program: ?
Example:
id 100043579 - added 100000000 = id Original 043579

Do you mean something like

program: $#id - 100000000

?

I suggest you look at the template language documentation.

[dunhill]

Originally Posted by chaley

Do you mean something like

program: $#id - 100000000

?

I suggest you look at the template language documentation.

If something like that!
Thanks because I was thinking about it with this post and it was simpler
https://www.mobileread.com/forums/sh...17&postcount=8


Well not everything can be perfect.
First of all I must say that I lack command of pyton, how could you add conditionals.
Example:
what remains if the number is between 10000000 and 10999999 only

[ownedbycats]

Something like this should work.

program:
## obviously replace $#yournum with your column
	if 
			$#yournum>=#10000000
		&& 
			$#yournum<=#10999999
	then
## using 'round' to fix the float/decimal output I got in my test
		round(subtract($#yournum, 100000000))

	else
		$#yournum

	fi

You'll want the "else $#yournum" or it will give you a blank for those instances.

[dunhill]

Originally Posted by ownedbycats

Something like this should work.

program:
## obviously replace $#yournum with your column
	if 
			$#yournum>=#10000000
		&& 
			$#yournum<=#10999999
	then
## using 'round' to fix the float/decimal output I got in my test
		round(subtract($#yournum, 100000000))

	else
		$#yournum

	fi

You'll want the "else $#yournum" or it will give you a blank for those instances.

Thank you very much, that solves the problem

[ownedbycats]

I use this as a stored template, readstatus().

Note that #percentread is integer and #readinglist is series-like managed with the Reading List plugin.

program:

	if $$#percentread >=#1 && $$#percentread <=#99
	then 'currentlyreading' 

	elif "To Be Read" in $#readinglist && $$#percentread ==#0
	then 'toberead' 

	elif $$#percentread >=#100
	then 'read' 

	elif $$#percentread == 'None'
	then 'undefined' 

	elif $$#percentread >=#0
	then 'unread' 

	fi

This allows the user to use readstatus() == 'currentlyreading' or '(unread|toberead)' in readstatus() in templates rather than checking the columns directly.

It would probably also work as a composite column.

[Arbait]

Please, more skilled than me, this problem really overwhelms me, please help.
I have all the books in this format.
W E Johns - [Biggles 31] - Biggles Delivers the Goods (epub).epub
What is the correct way to import books into Calibre?

Thank you and excuse the beginner question.

edit:
If i use

(?P<author>[^_-]+) -?\s*(?P<series>[^_0-9-]*)(?P<series_index>[0-9]*)\s*-\s*(?P<title>[^_].+) ?

is working ok but only if the file is in the format
W E Johns - Biggles 31 - Biggles Delivers the Goods (epub).epub
so no square brackets ...