Removing "and" from author split

[PatNY]

The default is to split authors on the word "and" which is causing havoc with the authors in my Calibre db. I saw the tweak to fix this, but it is a regex expression and I'm not exactly sure how to tweak it.

Here is the default:

authors_split_regex = '(?i),?\\s+(and|with)\\s+'

Do I simply remove the word "and" so it looks like this? ...

authors_split_regex = '(?i),?\\s+(|with)\\s+'

I know regex can be finicky and I don't want to break any other part of the expression by simply deleting the word.

--Pat

[theducks]

Originally Posted by PatNY

The default is to split authors on the word "and" which is causing havoc with the authors in my Calibre db. I saw the tweak to fix this, but it is a regex expression and I'm not exactly sure how to tweak it.

Here is the default:

authors_split_regex = '(?i),?\\s+(and|with)\\s+'

Do I simply remove the word "and" so it looks like this? ...

authors_split_regex = '(?i),?\\s+(|with)\\s+'

I know regex can be finicky and I don't want to break any other part of the expression by simply deleting the word.

--Pat

also remove the 'or' |

[PatNY]

Thanks, duck. That works

But now I have another issue related to this author split.

Background: I added a cookbook whose author is "Better Homes and Gardens." Before I made the tweak, Calibre would automatically split the author into 2: "Better Homes" and "Gardens." Additionally, an ampersand would automatically replace the "and."

Now, after the tweak, there is one author and Calibre retains the "and" in the author's name, which is correct. However, in the tag browser, the author is listed as "Gardens, Better Homes and" under the G's.

How do I get it to only show as "Better Homes and Gardens" under the B's?

For the metadata on this book, I have "Better Homes and Gardens" in both the Author and Author Sort fields.

--Pat

[Adoby]

Manually update the author_sort field to what you think it should be. Done!

[theducks]

Originally Posted by PatNY

Thanks, duck. That works

But now I have another issue related to this author split.

Background: I added a cookbook whose author is "Better Homes and Gardens." Before I made the tweak, Calibre would automatically split the author into 2: "Better Homes" and "Gardens." Additionally, an ampersand would automatically replace the "and."

Now, after the tweak, there is one author and Calibre retains the "and" in the author's name, which is correct. However, in the tag browser, the author is listed as "Gardens, Better Homes and" under the G's.

How do I get it to only show as "Better Homes and Gardens" under the B's?

For the metadata on this book, I have "Better Homes and Gardens" in both the Author and Author Sort fields.

--Pat

Instead of messing up normal parsing of authors, try using a NBSP between the and

Better Homes*and*Gardens

There is always 1
Just to make our lives
A is for Apple is not is for Apple, A

[PatNY]

Originally Posted by Adoby

Manually update the author_sort field to what you think it should be. Done!

I already did in the metadata editor. The problem is that in the tag browser where it has the authors, the author is not listed correctly as "Better Homes and Gardens" under the B's. Instead it shows up as "Gardens, Better Homes and" under the G's.

There must be some other tweak I'm missing.

--Pat

[PatNY]

Originally Posted by theducks

Instead of messing up normal parsing of authors, try using a NBSP between the and

Better Homes*and*Gardens

Huh?

Which field?

--Pat

[theducks]

Originally Posted by PatNY

Huh?

Which field?

--Pat

In the Main (Authors), the the calculated sort might ignore the space when parsing the sort.

But you can always hand correct the 'Master' Sort
In the Tag Browser (Authors): Right click: Manage Authors: <select>

Fixing it (the sort column) there, affects ALL books with that name

[PatNY]

Originally Posted by theducks

In the Main (Authors), the the calculated sort might ignore the space when parsing the sort.

But you can always hand correct the 'Master' Sort
In the Tag Browser (Authors): Right click: Manage Authors: <select>

Fixing it (the sort column) there, affects ALL books with that name

Oh great. That did the trick! I didn't know you could edit the authors over in the tag browser. I didn't need to put in nbsp, either -- just "Better Homes and Gardens" and it shows up properly now.

Thanks, ducks!

--Pat

[BetterRed]

Originally Posted by PatNY

Oh great. That did the trick! I didn't know you could edit the authors over in the tag browser. I didn't need to put in nbsp, either -- just "Better Homes and Gardens" and it shows up properly now.

Thanks, ducks!

--Pat

I think you can also override the author_sort in Manage Authors. Right click author name in Book details and select Manage Authors; or go the long way via the Alter Tag Browser button at the bottom of the Tag browser.

BR

[PatNY]

Originally Posted by BetterRed

I think you can also override the author_sort in Manage Authors. Right click author name in Book details and select Manage Authors; or go the long way via the Alter Tag Browser button at the bottom of the Tag browser.

BR

Thanks. That's the exact field I edited. The Author field was fine. It was just the sort field that was off, despite what I had specified in the metadata editor.

--Pat

[BetterRed]

Originally Posted by PatNY

Thanks. That's the exact field I edited. The Author field was fine. It was just the sort field that was off, despite what I had specified in the metadata editor.

--Pat

My experience is that you can't override the author sort rules in the Metadata Edit dialogue, you can only do it in the Tag Browser (as described by theducks) or in the Manage Authors list - maybe its depends on the values in the tweaks.

I don't use Metadata Edit, I edit the metadata in the book list cells, and I don't show the Tag Browser - that's why I use the right click on author name in Book Details pane (the one with the cover to left of, or under, the book list)

BR