Thread: How do I automatically remove second and subsequent authors?
View Single Post
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: 31,109
Karma: 60406498
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