MobileRead Forums - View Single Post - regex to add books; filenames with only underscores as separators

Adoby · 01-15-2014, 04:08 AM

You may not need the filename. If there is a ISBN-number in the book, you can use the ISBN-plugin to extract it, and then download the metadata using only that.

Or you can read in the whole filename to the title and the use bulk metadata search and replace, with regexp, to set the author.

[^_]+ will match a string until there is a underscore.

Search title for

^([^_]+)_([^_]+)_(.+)$

And replace author with

\1 \2

(or possibly \2 \1 if you want firstname surname)

Then do the same but replace title with

\3

Not tested...

I leave it to you to figure out how to remove underscores from the title.

01-15-2014, 04:08 AM	#2
Adoby Handy Elephant Posts: 1,736 Karma: 26785668 Join Date: Dec 2009 Location: Southern Sweden, far out in the quiet woods Device: Thinkpad E595, Ubuntu Mate, Huawei Mediapad 5, Bouye Likebook Plus	You may not need the filename. If there is a ISBN-number in the book, you can use the ISBN-plugin to extract it, and then download the metadata using only that. Or you can read in the whole filename to the title and the use bulk metadata search and replace, with regexp, to set the author. [^_]+ will match a string until there is a underscore. Search title for ^([^_]+)_([^_]+)_(.+)$ And replace author with \1 \2 (or possibly \2 \1 if you want firstname surname) Then do the same but replace title with \3 Not tested... I leave it to you to figure out how to remove underscores from the title. Last edited by Adoby; 01-15-2014 at 04:13 AM.