View Single Post
Old 01-23-2019, 02:33 AM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
I started with:

Search field: title
Search for:
Code:
.*- (\d+) (\w{3}).*
Replace with: \2 \1
Destination field: pubdate

And that worked (though I didn't try all months). Then I thought to try:

Search field: title
Search for:
Code:
.*- (\d+) (\w+)
Replace with: \2 \1
Destination field: pubdate

And it worked as well.

But, the simplest is:

Search field: title
Search for:
Code:
.*- (.*)
Replace with: \1
Destination field: pubdate

None of these would handle a second dash in the title. And it will fail if the month is misspelt.
davidfor is offline   Reply With Quote