MobileRead Forums - View Single Post - How do I automatically remove second and subsequent authors?

makaza · 05-08-2012, 06:08 PM

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

05-08-2012, 06:08 PM	#1
makaza Member 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