Help with Regexp for importing Magazines

[donnelyn]

Hi,

I am trying to import magazines into calibre and I want to have the Year imported into Series and Month (in numerical form) into Series Index.

The filenames are in the form of
Analog Science Fiction and Fact, 2008-03, March 2008.mobi
Analog Science Fiction and Fact, 2008-01, January-February 2008.mobi

but I could rename them to the following form if that's easier

Analog Science Fiction and Fact - 2008-03 - March 2008.mobi

I was using the following regexp
(?P<title>.+) ?\s*(?P<series>[0-9][^_-]+) -?\s*(?P<series_index>[0-9]*)\s*-\s*

and test filename Analog Science Fiction and Fact - 2008-03 - March 2008.mobi

But it includes the year as part of the title and puts the number of the month into the series instead of the series index.

Can any kind soul offer me some help please

[theducks]

Originally Posted by donnelyn

Hi,

I am trying to import magazines into calibre and I want to have the Year imported into Series and Month (in numerical form) into Series Index.

The filenames are in the form of
Analog Science Fiction and Fact, 2008-03, March 2008.mobi
Analog Science Fiction and Fact, 2008-01, January-February 2008.mobi

but I could rename them to the following form if that's easier

Analog Science Fiction and Fact - 2008-03 - March 2008.mobi

I was using the following regexp
(?P<title>.+) ?\s*(?P<series>[0-9][^_-]+) -?\s*(?P<series_index>[0-9]*)\s*-\s*

and test filename Analog Science Fiction and Fact - 2008-03 - March 2008.mobi

But it includes the year as part of the title and puts the number of the month into the series instead of the series index.

Can any kind soul offer me some help please

You do need to include the Month AND year as the title to avoid the Duplicate Title issue.
I also created series hierarchy to sort in order

[Starson17]

Originally Posted by donnelyn

test filename Analog Science Fiction and Fact - 2008-03 - March 2008.mobi

But it includes the year as part of the title and puts the number of the month into the series instead of the series index.

Can any kind soul offer me some help please

Try this:

(?P<title>.+), (?P<series>[0-9]+)-(?P<series_index>[0-9]+)

[donnelyn]

Starson,

Thank you for your help.

That works just the way I want it to.

You've saved me hours of manually entering the information myself.

[donnelyn]

theducks,

Thank for pointing out the duplicate issue I will rename my files to get around that.

e.g.
Analog Science Fiction and Fact September 2010, 2010-09.mobi

[Starson17]

Originally Posted by donnelyn

Starson,

Thank you for your help. The end of the regex you posted seems to be missing some code from the end.

My highlight didn't reach the end before I copied and pasted I fixed it in my post. Just add "]+" minus the quotes. It worked fine for my test.