Help with regular expressions

[jevonbrady]

Hi,
I have some books that have been named in the following manner.

title [author, published year]{some text}.pdf

e.g. Rethink ~ Cut Costs Boost Innovation [Ric Merrifield, 2009]{Summary}.pdf

I want to add these correctly in calibre i.e. get title, author and published year information, while ignoring the string {Summary}.

What would be the regular expression for this? I am a complete newbie here so please help.

[Manichean]

There's a tutorial for regular expressions available. I'm a little short on time right now, so I can't be more helpful, but I should be able to write a little more by tomorrow, if noone else has done it by then.

[Starson17]

Originally Posted by Manichean

if noone else has done it by then.

This will do it. The published date may be funky:

(?P<title>[^_-]+) \[(?P<author>[^_0-9-]*), (?P<published>[0-9]*)]

[jevonbrady]

Thanks, that worked! Is this standard python? Asking since I want to start doing this myself at some point in time.

[jevonbrady]

Actually, I have a followup question. I have many books currently named such that the tags are included in their names. The tags are always included in curly braces. e.g. consider the previous book I had mentioned.

Rethink ~ Cut Costs Boost Innovation [Ric Merrifield, 2009].pdf

If there were tags for this book, the name of the book would be as follows:

Rethink ~ Cut Costs Boost Innovation [Ric Merrifield, 2009]{Innovation, Cost Control}.pdf

How would the regular expression be changed to import the tags as well? This would save me a huge amount of work to classify articles and books. Thanks in advance.

BTW, I tried the following:

(?P<title>[^_-]+) \[(?P<author>[^_0-9-]*), (?P<published>[0-9]*)] \{(?P<tags>[^_0-9-]*)}

but that just imports the entire filename as title, which does not help me at all! I also used <tag> for tag. Any pointers?

[Starson17]

Originally Posted by jevonbrady

Thanks, that worked! Is this standard python? Asking since I want to start doing this myself at some point in time.

Yes, it's standard.

[Starson17]

Originally Posted by jevonbrady

Actually, I have a followup question. I have many books currently named such that the tags are included in their names. The tags are always included in curly braces. e.g. consider the previous book I had mentioned.

Rethink ~ Cut Costs Boost Innovation [Ric Merrifield, 2009].pdf

If there were tags for this book, the name of the book would be as follows:

Rethink ~ Cut Costs Boost Innovation [Ric Merrifield, 2009]{Innovation, Cost Control}.pdf

How would the regular expression be changed to import the tags as well? This would save me a huge amount of work to classify articles and books. Thanks in advance.

BTW, I tried the following:

(?P<title>[^_-]+) \[(?P<author>[^_0-9-]*), (?P<published>[0-9]*)] \{(?P<tags>[^_0-9-]*)}

but that just imports the entire filename as title, which does not help me at all! I also used <tag> for tag. Any pointers?

You can't directly import into the tags field. The work-around is to import them into another field and then do a search and replace to move them into tags.