Bulk metadata edit to add date from filename

Silvercat17 · 11-15-2018, 11:24 PM

I've got a ton of old pulp magazine scans and some of the filenames have dates. I'm sure there's a way to use the regular expression function in bulk metadata edit to pull out the publication date, but I can't figure it out.

Example file names:
Thrilling Wonder Stories v19n03 (1941-03)
Future Science Fiction #28 (12-1955)
(I'm assuming I'd have to do month-first and year-first separately)

Suggestions?

Thanks.

Silvercat17 · 11-16-2018, 06:38 PM

I figured it out, so here's how for the next person who needs it.

Example file name: Science Stories 123 (02-1949)

Search field: Title
Search for: Science Stories \d\d\d \((\d\d-\d\d\d\d)\)
Replace with: \1
Destination field: pubdate

The key part that I was missing was (\d\d-\d\d\d\d). Gotta wrap it in parentheses.

11-15-2018, 11:24 PM	#1
Silvercat17 Junior Member Posts: 2 Karma: 12 Join Date: Nov 2018 Device: kindle fire	Bulk metadata edit to add date from filename I've got a ton of old pulp magazine scans and some of the filenames have dates. I'm sure there's a way to use the regular expression function in bulk metadata edit to pull out the publication date, but I can't figure it out. Example file names: Thrilling Wonder Stories v19n03 (1941-03) Future Science Fiction #28 (12-1955) (I'm assuming I'd have to do month-first and year-first separately) Suggestions? Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
metadata from filename - published date	gelbmitschwarzen	Library Management	5	03-17-2024 06:16 AM
Changing metadata(title and author) in bulk/by macro from filename possible?	thosedays	Reading and Management	0	10-20-2016 08:17 AM
Bulk Metadata Edit of Series Name	Larla	Library Management	3	07-07-2016 07:54 AM
Edit metadata publish date for a date BC	RickLeFeuvre	Calibre	2	08-28-2014 11:53 PM
Metadata Edit: Bulk vs Individual	RichieTheK	Calibre	1	06-19-2013 11:07 PM

11-16-2018, 06:38 PM	#2
Silvercat17 Junior Member Posts: 2 Karma: 12 Join Date: Nov 2018 Device: kindle fire	I figured it out, so here's how for the next person who needs it. Example file name: Science Stories 123 (02-1949) Search field: Title Search for: Science Stories \d\d\d \((\d\d-\d\d\d\d)\) Replace with: \1 Destination field: pubdate The key part that I was missing was (\d\d-\d\d\d\d). Gotta wrap it in parentheses.

Advert