Regex in importing help.

[xd1986k]

Hello.
I have a bunch of files on my desktop that I'd like to import without a ton of manual metadata editing. I noticed the Regular Expression import from filename. I'm gonna get around to regex one of these days but in the meantime I'd be grateful if someone helped me.
My files on hard disk are arranged as such.
[Novel] The Top (Nein) 01 -e-
I need to import them in the following format.
Title=The Top 01
Series=The Top [01]
Alternate Title(Self Made Field)=Nein
Status(Self Made Field)=-e-
Thanks for the help.

[eschwartz]

You can't put part of the filename into two different fields.
Also, you cannot use custom columns in the adding regex.

[theducks]

Originally Posted by eschwartz

You can't put part of the filename into two different fields.
Also, you cannot use custom columns in the adding regex.

Bulk Metadata edit Search and Replace can copy to any field (of the correct type)

[eschwartz]

Excellent point... so you could import using

(?P<comments>.*)

And then select all books, select Edit Metadata, go to the Search and replace tab, and select
Search mode: Regular Expression
Search field: comments
Search for:

\[Novel\] ([^)(]+)\((.+)\) (\d+) (.*)

Then toggle through the following Replace with and Destination field sets:

for:
title: \1 -- #alt_title: \2 -- series: \1 -- series_index: \3 #status: \4

Replace with: \1
Destination field: title
---------------------------
Replace with: \2
Destination field: #alt_title
---------------------------
Replace with: \1
Destination field: series
---------------------------
Replace with: \3
Destination field: series_index
---------------------------
Replace with: \4
Destination field: #status


Wheeeee! But ugly as heck and takes quite a few steps. Definitely faster than hand-editing.

@xd1986k, you got that?

[gbm]

Calibre-Preferences- adding books-configure metadata from file name

(?P<author>[^_-]+) -?\s*(?P<series>[^_0-9-]*)(?P<series_index>[0-9]*)\s*-\s*(?P<title>[^_].+) ?

^((?P<author>([^\-_0-9]+)(?=\s*-\s*)(?!\s*-\s*[0-9.]+)|\b))(\s*-\s*)?(\[?(?P<series>[^0-9\-]+) (- )?(?P<series_index>[0-9.]+)\]?\s*-\s*)?(?P<title>[a-zA-Z1-9 ]+).+

example filename: Charles Sheffield - [Cold as Ice 03] - Dark as Day

luck
bernie

[eschwartz]

Originally Posted by gbm

Calibre-Preferences- adding books-configure metadata from file name

(?P<author>[^_-]+) -?\s*(?P<series>[^_0-9-]*)(?P<series_index>[0-9]*)\s*-\s*(?P<title>[^_].+) ?

^((?P<author>([^\-_0-9]+)(?=\s*-\s*)(?!\s*-\s*[0-9.]+)|\b))(\s*-\s*)?(\[?(?P<series>[^0-9\-]+) (- )?(?P<series_index>[0-9.]+)\]?\s*-\s*)?(?P<title>[a-zA-Z1-9 ]+).+

luck
bernie

That would work even better if it related to the OP's needs.

[gbm]

Originally Posted by eschwartz

That would work even better if it related to the OP's needs.

He is importing ebooks, he can play with the regex to get it to his needs.

That will fill the metadata fields from the file name.

Hello.
I have a bunch of files on my desktop that I'd like to import without a ton of manual metadata editing. I noticed the Regular Expression import from filename. I'm gonna get around to regex one of these days but in the meantime I'd be grateful if someone helped me.

bernie

[eschwartz]

Alternatively, say:

Here is a handy link to a regex guide.
Importing metadata from filenames uses named capturing groups (to match the metadata field names).

Which would be helpful information, insomuch as it relates to how to do it, rather than canned solutions for an entirely different need (in a thread asking for canned solutions, without pointing out that those are sample concepts).

[xd1986k]

Originally Posted by eschwartz

Excellent point... so you could import using

(?P<comments>.*)

And then select all books, select Edit Metadata, go to the Search and replace tab, and select
Search mode: Regular Expression
Search field: comments
Search for:

\[Novel\] ([^)(]+)\((.+)\) (\d+) (.*)

Then toggle through the following Replace with and Destination field sets:

for:
title: \1 -- #alt_title: \2 -- series: \1 -- series_index: \3 #status: \4

Replace with: \1
Destination field: title
---------------------------
Replace with: \2
Destination field: #alt_title
---------------------------
Replace with: \1
Destination field: series
---------------------------
Replace with: \3
Destination field: series_index
---------------------------
Replace with: \4
Destination field: #status


Wheeeee! But ugly as heck and takes quite a few steps. Definitely faster than hand-editing.

@xd1986k, you got that?

Thanks a lot. Got my whole library set up in four steps .

[eschwartz]

Originally Posted by xd1986k

Thanks a lot. Got my whole library set up in four steps .