Regular Expression Request for Author Custom Field

Incanus · 03-11-2019, 09:03 AM

Hello:

I'd like some help with regular expressions. I'm attempting to create two custom fields:

Calibre's Authors field may contain many authors, but I need to create a "First Author" custom field with the first Author of the Authors field
Having that, I need a custom field that gives me the initial letter of the "First Author"'s name (not the first letter of the "First Author" last name )

Awaiting your kind reply,

[INCANUS]

theducks · 03-11-2019, 10:36 AM

While the sample shows Author_sort, it works with any text type field

Code:

 {authors[0]}

Note also, this depends on what sort/name rules you have applied (expects Fn Ln)

Incanus · 03-11-2019, 10:42 AM

Quote:

Originally Posted by theducks

Code:

 {authors[0]}

Note also, this depends on what sort/name rules you have applied (expects Fn Ln)

Thank you very much for your prompt and complete reply!

Now, I'm only missing the answer for #2 on my original post :-P

Very gratefully yours,

[INCANUS]

Incanus · 03-11-2019, 11:57 AM

It would seem the answer for #2 is from the following post:

Quote:

Originally Posted by Sweetpea

{#first_letter} is a compositie field: {author_sort:.1}

In my case, if

Code:

#first_author = {authors[0]}

Then

Code:

#first_author_letter = {#first_author:.1}

Can anyone please verify?

[INCANUS]

theducks · 03-11-2019, 02:11 PM

Quote:

Originally Posted by Incanus

Thank you very much for your prompt and complete reply!

Now, I'm only missing the answer for #2 on my original post :-P

Very gratefully yours,

[INCANUS]

This only returns the first letter (and I think this is limited to the first Author)
My use was to create a folder by Authors Ln LETTER, to hod books by Author

Code:

 Authors_ {author_sort[0]}/{authors}-{title}

Incanus · 03-11-2019, 02:37 PM

Thanks for your input, I'll do some testing to check how it is actually working.

Gratefully,

[INCANUS]

Incanus · 03-11-2019, 10:08 PM

After some experimentartion, this is what worked for me:

Code:

First Author = {author:sublist(0,1,&)}

First Letter of First Author = {author[0]}

So, to copy files to a disk or device using a related structure, it would go like this:

Code:

{author[0]}/{author:sublist(0,1,&)}/{title} - {author:sublist(0,1,&)}

Works like a charm!

Cheers,

[INCANUS]

theducks · 03-11-2019, 11:45 PM

03-11-2019, 09:03 AM	#1
Incanus Incanus Posts: 313 Karma: 210 Join Date: Oct 2017 Location: Chile Device: Boyue Likebook T80D	Regular Expression Request for Author Custom Field Hello: I'd like some help with regular expressions. I'm attempting to create two custom fields: Calibre's Authors field may contain many authors, but I need to create a "First Author" custom field with the first Author of the Authors field Having that, I need a custom field that gives me the initial letter of the "First Author"'s name (not the first letter of the "First Author" last name ) Awaiting your kind reply, [INCANUS] Last edited by Incanus; 03-11-2019 at 09:04 AM. Reason: Typo

03-11-2019, 10:08 PM	#7
Incanus Incanus Posts: 313 Karma: 210 Join Date: Oct 2017 Location: Chile Device: Boyue Likebook T80D	Regular Expression Request for Author Custom Field After some experimentartion, this is what worked for me: Code: First Author = {author:sublist(0,1,&)} First Letter of First Author = {author[0]} So, to copy files to a disk or device using a related structure, it would go like this: Code: {author[0]}/{author:sublist(0,1,&)}/{title} - {author:sublist(0,1,&)} Works like a charm! Cheers, [INCANUS]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Have a Regular Expression problem with Author Field	searcygr	Library Management	2	09-21-2018 11:33 AM
Adding Books: regular expression request	maxlinworm	Library Management	1	02-17-2018 07:32 PM
Calibre book adding: Regular expression request...	Tweetygirl10111	Calibre	13	07-13-2017 10:14 PM
Calibre book adding: Regular expression request...	Spiffy	Calibre	34	01-19-2016 02:03 PM
Regular expression: swap author firstname and lastname	An_od	Library Management	2	01-17-2013 11:55 AM

03-11-2019, 10:36 AM	#2
theducks Well trained by Cats Posts: 31,270 Karma: 61916422 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	While the sample shows Author_sort, it works with any text type field Code: {authors[0]} Note also, this depends on what sort/name rules you have applied (expects Fn Ln)

03-11-2019, 02:37 PM	#6
Incanus Incanus Posts: 313 Karma: 210 Join Date: Oct 2017 Location: Chile Device: Boyue Likebook T80D	Thanks for your input, I'll do some testing to check how it is actually working. Gratefully, [INCANUS]

03-11-2019, 11:45 PM	#8
theducks Well trained by Cats Posts: 31,270 Karma: 61916422 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A

Advert

Advert