MobileRead Forums - View Single Post - Need Help With "Regular Expression Syntax"

dkritso109 · 10-04-2010, 09:54 AM

ok first off kacir your awesome,
(?P<author>[^-]+)( - \[?(?P<series>[^-]+)(\[| )+(?P<series_index>[0-9]+)\]?)? - (?P<title>.+)
this works great, this totaly solved my author sort issue.
the only problem is with the series numbers

Foster, Alan Dean - Catechist 02 - Carnivores of Light and Darkness

turns into this

Carnivores of Light and Darkness Foster, Alan Dean

please also keep in mind that i am having trouble keeping up with yalls techie kung-fu.
you guys are definately experts at this, while i am a measly little business major.

also one more thing:
i know nothing about the search and replace function, all of my 4000 + books are already in the Alan Dean Foster format how do i change them all to Foster, Alan Dean. what exactly do i need to do?

so just to recap:
1. my series loses their numbering
2. search and replace all authors to the author sort format in the author box

thanks guys for your awesome help so far, yall rock!!!

p.s. can anyone lend me a well trained monkey???

10-04-2010, 09:54 AM	#26
dkritso109 Enthusiast Posts: 43 Karma: 10 Join Date: Jun 2010 Device: Kindle 3	ok first off kacir your awesome, (?P<author>[^-]+)( - \[?(?P<series>[^-]+)(\[\| )+(?P<series_index>[0-9]+)\]?)? - (?P<title>.+) this works great, this totaly solved my author sort issue. the only problem is with the series numbers Foster, Alan Dean - Catechist 02 - Carnivores of Light and Darkness turns into this Carnivores of Light and Darkness Foster, Alan Dean please also keep in mind that i am having trouble keeping up with yalls techie kung-fu. you guys are definately experts at this, while i am a measly little business major. also one more thing: i know nothing about the search and replace function, all of my 4000 + books are already in the Alan Dean Foster format how do i change them all to Foster, Alan Dean. what exactly do i need to do? so just to recap: 1. my series loses their numbering 2. search and replace all authors to the author sort format in the author box thanks guys for your awesome help so far, yall rock!!! p.s. can anyone lend me a well trained monkey???