MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page How do I automatically remove second and subsequent authors?

Notices

Reply
 
Thread Tools Search this Thread
Old 05-08-2012, 06:08 PM   #1
makaza
Member
makaza began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Jul 2010
Device: sony prs-505
How do I automatically remove second and subsequent authors?
Is there a way using regular expressions to remove second and subsequent authors from the AUTHORS column?

I have a large number of books which have more then one author and I wish to have the author column display only the first author.

The second(and subsequent) authors appear immediately after the first appearance of the ";" character - so I assume there must be a away to delete the " ;" character and everything after it?

Can anyone help - I've tried various expressions but havent achieved the desired result.
Many Thanks
Anzhelika
makaza is offline   Reply With Quote
Old 05-08-2012, 07:14 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,908
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by makaza View Post
Is there a way using regular expressions to remove second and subsequent authors from the AUTHORS column?

I have a large number of books which have more then one author and I wish to have the author column display only the first author.

The second(and subsequent) authors appear immediately after the first appearance of the ";" character - so I assume there must be a away to delete the " ;" character and everything after it?

Can anyone help - I've tried various expressions but havent achieved the desired result.
Many Thanks
Anzhelika
Each additional Author should follow the & sign

I think this might work:

Code:
(.+)\:.+
replace: \1
theducks is offline   Reply With Quote
Advert
Old 05-09-2012, 07:36 AM   #3
louwin
Newbie Nerd
louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.louwin ought to be getting tired of karma fortunes by now.
 
louwin's Avatar
 
Posts: 114
Karma: 1000354
Join Date: Feb 2012
Location: Perth, Western Australia
Device: iPad 3 64Gb Black
Shouldn't that colon be a semi-colon?
louwin is offline   Reply With Quote
Old 05-09-2012, 09:34 AM   #4
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,908
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by louwin View Post
Shouldn't that colon be a semi-colon?
Yes (Those durn keys are keep shifting case at the wrong time )
theducks is offline   Reply With Quote
Old 05-09-2012, 11:00 AM   #5
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,336
Karma: 8012652
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
FWIW, you can also replace the ';' with '&' so that calibre will know there are multiple authors. As it is, calibre thinks that there is one author with a lot of words in the name.
chaley is offline   Reply With Quote
Advert
Old 05-09-2012, 11:19 AM   #6
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,908
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by chaley View Post
FWIW, you can also replace the ';' with '&' so that calibre will know there are multiple authors. As it is, calibre thinks that there is one author with a lot of words in the name.
I should have thought of that solution
theducks is offline   Reply With Quote
Old 05-09-2012, 12:20 PM   #7
makaza
Member
makaza began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Jul 2010
Device: sony prs-505
Multiple Authors
Many thanks to you all for taking the trouble to respond.

I will try out the suggestions later today and let you know how I get on.
Regards
Anzhelika
makaza is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically remove tags when adding books garytshepherd Library Management 12 03-13-2012 11:16 AM
How to automatically remove old news? TechnoCat Calibre 3 01-18-2012 11:24 AM
Kindle - Automatically remove/archive old news ? Copenhagenmail Devices 8 12-14-2011 05:14 PM
RFE: Remove remove tags in bulk edit magphil Calibre 0 08-11-2009 10:37 AM
Short Fiction Authors, Various: Stories by Foreign Authors: Polish, Greek, Belgian. v1, 20 Feb 2008 Madam Broshkina Kindle Books (offline) 0 02-20-2008 08:41 PM


All times are GMT -4. The time now is 05:07 PM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.