Regular Expression Help

iKarampa · 12-03-2010, 10:09 AM

I have some ebooks in the format:

Scientific American - 1993.12 - Taming Africanized Killer Bees
Scientific American Online - 2006 #28 - Evolution

What is the correct regular expression to read all these?

Manichean · 12-03-2010, 10:13 AM

There's an introduction in the user manual.

iKarampa · 12-03-2010, 10:18 AM

Thank you,

I sincerely can not follow these, this is well above my understanding

kmack · 12-03-2010, 11:42 AM

"~^Scientific American"
Include the quotes, will get you everything that starts with the words Scientific American

Starson17 · 12-03-2010, 11:48 AM

Quote:

Originally Posted by kmack

"~^Scientific American"
Include the quotes, will get you everything that starts with the words Scientific American

I think he's looking for a regex to import them with at least title. There is no "correct" or "best" answer. He'd need to specify what metadata (author, pubdate, publisher, series name, series_index) he's trying to extract from the title to answer his question.

iKarampa · 12-03-2010, 11:56 AM

Thanks,

How would I use it to extract the info?

Scientific American - 1993.12 - Taming Africanized Killer Bees
Name=Scientific American
pubdate=1993.12
Title=Taming Africanized Killer Bees

For the other style:

Scientific American Online - 2006 #28 - Evolution

Name=Scientific American Online
not sure how I would store the 2006 #28 , maybe skip
Title=Taming Africanized Killer Bees

Quote:

Originally Posted by kmack

"~^Scientific American"
Include the quotes, will get you everything that starts with the words Scientific American

RobW · 12-11-2010, 05:31 AM

You could try...

^Scientific American.*?$

But not entirely sure from the question what you want to achieve. Could you give the original text and then the text you wamt to extract from it.

Adoby · 12-11-2010, 07:00 AM

Quote:

Originally Posted by iKarampa

How would I use it to extract the info?

You can't.

You can only extract Title, Authors, Series, Series index and ISBN using a regular expression as you add the book. Take a look at preferences for adding books.

But if you are in luck, the files you have may have all the correct metadata embeded in them. Then you can have Calibre read it directly from inside the file. Also something you specify in preferences for adding books.

iKarampa · 12-15-2010, 06:21 AM

Do you know the regular expression that would at least give me the title?

Perkin · 12-15-2010, 06:30 AM

Using the Scientific American as series a simple one would be

Code:

(?P<series>.*) - .* - (?P<title>.*)

iKarampa · 12-15-2010, 06:52 AM

Thank you for the reply.

I tried it with "Scientific American - 1993.12 - Taming Africanized Killer Bees" as test. It recognises "Scientific American - 1993" as title and for the series it gets no match.

Quote:

Originally Posted by Perkin

Using the Scientific American as series a simple one would be

Code:

(?P<series>.*) - .* - (?P<title>.*)

Manichean · 12-15-2010, 07:14 AM

Try

Code:

(?P<series>.*?) - .*? - (?P<title>.*?)

chaley · 12-15-2010, 07:16 AM

Quote:

Originally Posted by iKarampa

Thank you for the reply.

I tried it with "Scientific American - 1993.12 - Taming Africanized Killer Bees" as test. It recognises "Scientific American - 1993" as title and for the series it gets no match.

The regexp does work. See the attached screenshot of the test.

You probably didn't perform the secret handshake. For the tests to work, you must have a file extension on your file name.

iKarampa · 12-15-2010, 07:17 AM

Yes it works!
I did not know about the handshake!

Quote:

Originally Posted by Manichean

Try

Code:

(?P<series>.*?) - .*? - (?P<title>.*?)

12-03-2010, 10:09 AM	#1
iKarampa Nameless Being	Regular Expression Help I have some ebooks in the format: Scientific American - 1993.12 - Taming Africanized Killer Bees Scientific American Online - 2006 #28 - Evolution What is the correct regular expression to read all these?

12-15-2010, 06:30 AM	#10
Perkin Guru Posts: 657 Karma: 64171 Join Date: Sep 2010 Location: Kent, England, Sol 3, ZZ9 plural Z Alpha Device: Sony PRS-300, Kobo Aura HD, iPad (Marvin)	Using the Scientific American as series a simple one would be Code: (?P<series>.) - . - (?P<title>.*)

12-15-2010, 07:14 AM	#12
Manichean Wizard Posts: 3,130 Karma: 91256 Join Date: Feb 2008 Location: Germany Device: Cybook Gen3	Try Code: (?P<series>.?) - .? - (?P<title>.*?)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Regular Expression Help	Azhad	Calibre	86	09-27-2011 02:37 PM
Regular Expression Help	smartmart	Calibre	5	10-17-2010 05:19 AM
Need Help Creating a Regular Expression	Worm	Calibre	9	08-18-2010 01:20 PM
Help with the regular expression	Dysonco	Calibre	9	03-22-2010 10:45 PM
I don't know how to use wilcards and regular expression....	superanima	Sigil	4	02-21-2010 09:42 AM

12-03-2010, 10:13 AM	#2
Manichean Wizard Posts: 3,130 Karma: 91256 Join Date: Feb 2008 Location: Germany Device: Cybook Gen3	There's an introduction in the user manual.

12-03-2010, 10:18 AM	#3
iKarampa Nameless Being	Thank you, I sincerely can not follow these, this is well above my understanding

12-03-2010, 11:42 AM	#4
kmack Member Posts: 21 Karma: 87 Join Date: Jan 2008 Device: Nook, EBW-1150	"~^Scientific American" Include the quotes, will get you everything that starts with the words Scientific American

12-11-2010, 05:31 AM	#7
RobW Rob Wheeler (Kent, UK) Posts: 13 Karma: 50000 Join Date: Oct 2010 Location: Kent, UK Device: Sony PRS-650	You could try... ^Scientific American.*?$ But not entirely sure from the question what you want to achieve. Could you give the original text and then the text you wamt to extract from it.

12-15-2010, 06:21 AM	#9
iKarampa Nameless Being	Do you know the regular expression that would at least give me the title?