Plugboard, template, and custom composite column recipes

[chaley]

Try

program: list_equals(approximate_formats(), ',', 'pdf', ',', 'Yes', 'No')

[eschwartz]

You should be able to search for all books with only one format, PDF, using:

format:#=1 and format:"=PDF"

[theducks]

Originally Posted by EnergyLens

I thought this would be easy, but I am totally lost.

I know how to do a search for only PDF by excluding other formats, but I don't know how to use the template language to do the same...

Can someone give me a quick pointer?

search:

formats:#=1 and formats:PDF

Show only count of formats =1
and
show formats = PDF

[EnergyLens]

Originally Posted by chaley

Try

program: list_equals(approximate_formats(), ',', 'pdf', ',', 'Yes', 'No')

That's great! I was trying to use list_equals but was unaware of the program command. THANKS!

[eschwartz]

Originally Posted by theducks

search:

formats:#=1 and formats:PDF

Show only count of formats =1
and
show formats = PDF

Yes, it does.

Originally Posted by eschwartz

You should be able to search for all books with only one format, PDF, using:

format:#=1 and format:"=PDF"

[theducks]

Originally Posted by eschwartz

Yes, it does.

You forgot the S in formats

[eschwartz]

Originally Posted by theducks

You forgot the S in formats

I usually use the GUI for all this.

Either the online manual needs a correction or either one works. http://manual.calibre-ebook.com/gui....arch-interface

[crissman]

Quick question, just a quirk of mine, but annoying just the same..

{#stripped_series:shorten(4,-,4)}{series_index:0>3s| [|] }{title}

(I also have the corresponding columns)

A series that has multiple words like A Song of Ice and Fire gets shortened down to its initials which is perfect, what is bothersome to me is when a series like "The Coincidence" gets stripped into Coincidence which again is okay, but its shortened form it becomes Coin-ence.

What would I need to change in order for it to show instead either "Coincidence" or "The Coincidence" for series that are either a single word or preceded by "The" or "A" etc. yet still retain the "initial" values for a longer series name such as A Song of Ice and Fire (ASoIaF) or Lord of the Rings (LotR)

[EDIT] Kinda figured it out, I changed the value: shorten(4,-,4) to shorten(12,-,6), but now I am wondering what is the allowable amount of characters on a title field on a Kindle PW1 and a Kobo Aura HD?

Thanks yet again in advance for any help with this.

[DMee]

On a similar vein, rather than just the initials - is it possible to have the first x characters of each word?

Lor-of-the-Rin [01] etc ??

[eschwartz]

Originally Posted by crissman

Quick question, just a quirk of mine, but annoying just the same..

{#stripped_series:shorten(4,-,4)}{series_index:0>3s| [|] }{title}

(I also have the corresponding columns)

A series that has multiple words like A Song of Ice and Fire gets shortened down to its initials which is perfect, what is bothersome to me is when a series like "The Coincidence" gets stripped into Coincidence which again is okay, but its shortened form it becomes Coin-ence.

What would I need to change in order for it to show instead either "Coincidence" or "The Coincidence" for series that are either a single word or preceded by "The" or "A" etc. yet still retain the "initial" values for a longer series name such as A Song of Ice and Fire (ASoIaF) or Lord of the Rings (LotR)

[EDIT] Kinda figured it out, I changed the value: shorten(4,-,4) to shorten(12,-,6), but now I am wondering what is the allowable amount of characters on a title field on a Kindle PW1 and a Kobo Aura HD?

Thanks yet again in advance for any help with this.

It sounds like you just want {#stripped_series} without using shorten at all.

[eschwartz]

Originally Posted by DMee

On a similar vein, rather than just the initials - is it possible to have the first x characters of each word?

Lor-of-the-Rin [01] etc ??

Yes. The part in red is captured to make initials.

Name: #initials. Template: {#stripped_series:re([\s]?([^\s])[^\s]+(\s|$),\1)}

Change it to

([^\s]{1,x})

where x is the number of characters you want (including the first time).
So using {1,3} means use that set [^\s] at least once and not more than 3x.
{0,1} is another way of saying "?", or "optional". (Either match only the initial time, or not at all.)

For further information (that is, gory details ) on repeating characters see: http://www.regular-expressions.info/repeat.html#limit

[crissman]

Originally Posted by eschwartz

It sounds like you just want {#stripped_series} without using shorten at all.

Yes and No, Even though is a tad annoying to have a series truncated so abruptly, I do see the need for it on single word series that happens to be extra long and so I would still like to use it. Going to test out the lengths available to me on the Kindle to see what I can use.

I do like Dmee idea about having a few more letters on the Intitial Column

Name: #initials Template: {#stripped_series:re([\s]?([^\s]{1,3})[^\s]+(\s|$),\1)}

However I do get and error: I am sure it is something I am doing, but I can't see it, I copied and pasted from your post.

{#stripped_series:re([\s]?([^\s]{1,3})[^\s]+(\s|$),\1)}
Template Value: EXCEPTION: Value: unknown field 1,3

[eschwartz]

Originally Posted by crissman

Yes and No, Even though is a tad annoying to have a series truncated so abruptly, I do see the need for it on single word series that happens to be extra long and so I would still like to use it. Going to test out the lengths available to me on the Kindle to see what I can use.

I do like Dmee idea about having a few more letters on the Intitial Column

Name: #initials Template: {#stripped_series:re([\s]?([^\s]{1,3})[^\s]+(\s|$),\1)}

However I do get and error: I am sure it is something I am doing, but I can't see it, I copied and pasted from your post.

{#stripped_series:re([\s]?([^\s]{1,3})[^\s]+(\s|$),\1)}
Template Value: EXCEPTION: Value: unknown field 1,3

Ah, yes.

The brackets are reserved in template mode. That's why I like general program mode. Well, that and you can limit yourself to only using one custom column.

Use the general program mode version found here: http://manual.calibre-ebook.com/temp...l-program-mode
Simply fix the "stripped" variable.

PHP Code:

program:
#       compute the equivalent of the composite fields and store them in local variables
stripped = re(field('series'), '^(A|The|An)\s+', '');
shortened = shorten(stripped, 4, '-' ,4);
initials = re(stripped, '[\s]?([^\s])[^\s]+(\s|$)', '\1');

#       Format the series index. Ends up as empty if there is no series index.
#       Note that leading and trailing spaces will be removed by the formatter,
#       so we cannot add them here. We will do that in the strcat below.
#       Also note that because we are in 'program' mode, we can freely use
#       curly brackets in strings, something we cannot do in template mode.
s_index = template('{series_index:0>2.0f}');

#       print(stripped, shortened, initials, s_index);

#       Now concatenate all the bits together. The switch picks between
#       initials and shortened, depending on whether there is a space
#       in stripped. We then add the brackets around s_index if it is
#       not empty. Finally, add the title. As this is the last function in
#       the program, its value will be returned.
strcat(
    switch(
        stripped,
        '.\s',
        initials,
        '.',
        shortened,
        field('series')
    ),
    test(
        s_index,
        strcat(' [', s_index, '] '),
        ''
    ),
    field('title')
); 


[crissman]

Sounds like a good plan, will look into this.

Here goes another question, I already tried to post a reply but I think it got lost in the clouds

I would like to auto-populate a NON-user defined column "Tags" from my own User Defined Column for Genres in which I use a column type of "text, with a fixed permitted values" and list the various Genres I like to use rather then the mess that comes in from downloading the metadata.

I frequently share books with my Mother and as she uses calibre simple just to hold and send her books to her device. I do know I can have her recreate her library using my metadata.db, and then the information would be sent to her but I was just wondering if there was a way to do it this way?

[eschwartz]

In Bulk Edit Metadata, you can use regexes to search any one column and replace any one custom column -- does not have to be the same one.

You can also use a template as the search field.