{author_sort}. How to template-save the author's last name in capital letters?

[Latios]

Hello,

When I am using "saving ebooks to disc", there is a template that I can use to create the file name of that ebook that it is going to be save.

Today, I am wondering about the {author_sort}.

For example, I have a book where the author is "Aldous Huxley", and the title is "Brave New World".

If I use the template "{author_sort}.{title}", the new ebook file name will be:
Huxley, Aldous. Brave New World

But I would like to have the last name in capital letters. How can I make it to be like this: ???
HUXLEY, Aldous. Brave New World

How can I do that?

Thanks!

[Latios]

has anybody been able to do it or know how to do it?

[Latios]

any luck?? anyone knows??

[BetterRed]

There are string case changing and string manipulation functions in the Template language, see ==>> Function classification

BR

[Latios]

Thanks!! I have been reading it and trying options.

The only problem is that the command {author_sort} automatically grabs both FirstName and LastName and organizes them like "Huxley, Aldous"

So with the string case functions, it looks that I just can do either all capital letters or all lower letters.

How can I make ONLY the Last name to be in capital letters like "HUXLEY, Aldous"??

[davidfor]

Assuming all the author_sort names are in the format "LN, FN", then the following seems to work:

{author_sort:'strcat(uppercase(list_item($,0,',')),', ',list_item($,1,','))'}

The problem with that is if you have a book by Madonna or Cher.

And thinking about this, the following will work for those cases as well:

{author_sort:'contains($,",",strcat(uppercase(list_item($,0,",")),", ",list_item($,1,",")),uppercase($))'}

[Latios]

YES, IT WORKS VERY GOOD!

I just tried this one:

{author_sort:'contains($,",",strcat(uppercase(list_item($,0,",")),", ",list_item($,1,",")),uppercase($))'}

And I get:
- MADONNA
- HUXLEY, Aldous

So good!!! I couldnt even get to this point myself.

But now the only problem is when there is more than one author.

For example, with two authors:
When Author sort's metadata shows: Smith, Sam & Dallas, Ken
...applying the code you gave me, comes up like: SMITH, Sam & Dallas

For example, with more than two:
When Author sort's metadata shows: Ronald, Alex & Chan, Liu & Tiffany, Megan
...applying the code you gave me, comes up like: RONALD, Alex & Chan

It's weird, because it either omits the second author's first name, or also the other authors. I have tried other options, but it is going beyond my knowledge...

[Latios]

I think I am getting close how to fix it:

I have modified the code template like this:

{author_sort:'contains($,",",strcat(uppercase(list_item($,0,",")),", ",list_item($,1,","),", ",list_item($,2,","),", ",list_item($,3,",")),uppercase($))'}

And this is the new outcome:

When Author sort's metadata shows: Smith, Sam & Dallas, Ken
...applying the code you gave me, comes up like: SMITH, Sam & Dallas, Ken

For example, with more than two:
When Author sort's metadata shows: Ronald, Alex & Chan, Liu & Tiffany, Megan
...applying the code you gave me, comes up like: RONALD, Alex & Chan, Liu & Megan, Tiffany

The only thing missing now is to make the second and following last name's author into capital letters.

what am I missing?

[davidfor]

Originally Posted by Latios

I think I am getting close how to fix it:

I have modified the code template like this:

{author_sort:'contains($,",",strcat(uppercase(list_item($,0,",")),", ",list_item($,1,","),", ",list_item($,2,","),", ",list_item($,3,",")),uppercase($))'}

And this is the new outcome:

When Author sort's metadata shows: Smith, Sam & Dallas, Ken
...applying the code you gave me, comes up like: SMITH, Sam & Dallas, Ken

For example, with more than two:
When Author sort's metadata shows: Ronald, Alex & Chan, Liu & Tiffany, Megan
...applying the code you gave me, comes up like: RONALD, Alex & Chan, Liu & Megan, Tiffany

What I did didn't handle multiple authors.

The only thing missing now is to make the second and following last name's author into capital letters.

what am I missing?

For two names, it is:

{author_sort:'contains($,",",strcat(uppercase(list_item($,0,",")),", ",strcat(list_item(list_item($,1,","),0,"&")," & ",uppercase(list_item(list_item($,1,","),1,"&"))),", ",list_item($,2,","),", ",list_item($,3,",")),uppercase($))'}

But, doing it this way, means you need to know what is the maximum number of authors in the library. I think I have one with 17 authors, this would get absurd.

The way to do it is with a template function. To do this:
Open the calibre preferences and go to "Template functions"

1. In "Function" put "author_sort_capitalized".
2. In "Argument count" put "-1"
3. In "Program code" paste the following:
   

   def evaluate(self, formatter, kwargs, mi, locals):
       sort_data = mi.author_sort_map
       if not sort_data:
           return ''
       names = []
       for n in mi.authors:
           if n.strip():
               comma_index = sort_data.get(n).find(',')
               if comma_index > 0:
                   new_name = sort_data.get(n)[:comma_index].upper()
                   new_name += sort_data.get(n)[comma_index:]
               else:
                   new_name = sort_data.get(n).upper()
               names.append(new_name)
       return " & ".join(n for n in names)

   The formatting is important.
4. Press the "Create" button.
5. Press the "Apply" button and close the preferences.
6. Where you want to use this put:
   

   {:author_sort_capitalized()}

That seems to work here. There is probably a better way to do it, but, that's what comes to mind at the moment.

[chaley]

Originally Posted by davidfor

That seems to work here. There is probably a better way to do it, but, that's what comes to mind at the moment.

A template function is probably the best because it is the fastest. However, should you want to do it in the template language, this seems to work.

program: list_re_group(field('author_sort'), ' & ', '.', '(.*?)(,|$)(.*)', '{$:uppercase()}')

It first separates the list of authors, Then for each author it applies a regexp to find the value before the comma and uppercases that value. If there isn't a comma then the entire author is uppercased.

[davidfor]

Originally Posted by chaley

A template function is probably the best because it is the fastest. However, should you want to do it in the template language, this seems to work.

program: list_re_group(field('author_sort'), ' & ', '.', '(.*?)(,|$)(.*)', '{$:uppercase()}')

It first separates the list of authors, Then for each author it applies a regexp to find the value before the comma and uppercases that value. If there isn't a comma then the entire author is uppercased.

Well, I did say there was probably a better way to do it

I'm not sure if I had read the description of the list_re and list_re_group functions. If I did, they didn't sink in. But, with that example, it's obvious what they do.

[chaley]

For completeness, here is the same solution in template program mode instead of general program mode:

{author_sort:'list_re_group($, ' & ', '.', '(.*?)(,|$)(.*)', '[[$:uppercase()]]')'}

[Latios]

@davidfor and @chaley !! IT COMPLETLY WORKS WITH EVERY SITUATION!!

One author, two, three, four... single word authors.. etc etc.

nothing else to say but thank you and that you are great!!!!