Extract Pubdate from imported Magazines

StickyC · 01-22-2019, 11:50 PM

I have a slew of periodicals that I've imported that are in the general format of
Title: Title - YYYY Mmm
(for instance MagPi - 2017 October)

I'm trying to figure out how (if there's a way) to use Edit Metadata In Bulk to parse the titles, extract the date info (via RegEx) and insert it into the PubDate field for each title.

Is this possible? I've had zero luck so far with a wide variety of options on the Search and replace dialog in Edit meta information.

Thanks!

davidfor · 01-23-2019, 03:33 AM

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.

01-22-2019, 11:50 PM	#1
StickyC Junior Member Posts: 7 Karma: 10 Join Date: Feb 2008 Device: Kindle	Extract Pubdate from imported Magazines I have a slew of periodicals that I've imported that are in the general format of Title: Title - YYYY Mmm (for instance MagPi - 2017 October) I'm trying to figure out how (if there's a way) to use Edit Metadata In Bulk to parse the titles, extract the date info (via RegEx) and insert it into the PubDate field for each title. Is this possible? I've had zero luck so far with a wide variety of options on the Search and replace dialog in Edit meta information. Thanks!

01-23-2019, 03:33 AM	#2
davidfor Grand Sorcerer 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pubdate from nomefile	raffabelli	Library Management	0	05-04-2017 08:57 AM
Calibre 2.70 - {pubdate} is 1 year off	DrChiper	Calibre	2	10-14-2016 09:39 AM
Pubdate in catalogs	BetterRed	Calibre	0	09-03-2013 02:54 AM
Set pubdate by script	Pete69	Library Management	3	07-05-2013 11:35 AM
Extract Pubdate	Martin Hollander	Calibre	10	01-10-2013 09:30 AM

Advert