regular expression to convert character when adding book

comox · 08-23-2014, 12:56 PM

Hoping there might be a regular expression expert that can help me.

I would like to convert "_" to ":" in the file name title when adding books.

For example:
John Doe - Cooking_ With Gas - 2014

Using:
(?P<author>[^_]+) - (?P<title>.+) - (?P<published>.+)

Is there a modification I can make so that the imported title is "Cooking: With Gas".

theducks · 08-23-2014, 01:51 PM

Quote:

Originally Posted by comox

Hoping there might be a regular expression expert that can help me.

I would like to convert "_" to ":" in the file name title when adding books.

For example:
John Doe - Cooking_ With Gas - 2014

Using:
(?P<author>[^_]+) - (?P<title>.+) - (?P<published>.+)

Is there a modification I can make so that the imported title is "Cooking: With Gas".

colon is a reserved filesystem character.
C:
LPT1:
NUL:

comox · 08-23-2014, 01:55 PM

Thanks. I understand colon is reserved. That's why ":" was converted to "_" when saving the title in the filename. I would like to reverse the process and convert "_" to ":" when adding a book to my library.

kovidgoyal · 08-23-2014, 01:57 PM

You cannot run regular expression on filenames while importing, you can run them in bulk via the search replace tab of the bulk metadata edit dialog, after importing.

comox · 08-23-2014, 02:15 PM

got it, thanks

08-23-2014, 12:56 PM	#1
comox Enthusiast Posts: 38 Karma: 10 Join Date: Jan 2011 Device: none	regular expression to convert character when adding book Hoping there might be a regular expression expert that can help me. I would like to convert "_" to ":" in the file name title when adding books. For example: John Doe - Cooking_ With Gas - 2014 Using: (?P<author>[^_]+) - (?P<title>.+) - (?P<published>.+) Is there a modification I can make so that the imported title is "Cooking: With Gas".

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre book adding: Regular expression request...	Spiffy	Calibre	34	01-19-2016 02:03 PM
Regular Expression adding book published date	jbcmars	Calibre	2	01-08-2011 10:23 PM
Adding Books, regular expression	smarties86	Calibre	4	12-19-2010 09:18 AM
Regular Expression on adding books.	Lokro	Calibre	4	11-06-2010 12:05 PM
Regular Expression For Adding Books	jhart711	Calibre	3	09-27-2010 07:51 AM

08-23-2014, 01:55 PM	#3
comox Enthusiast Posts: 38 Karma: 10 Join Date: Jan 2011 Device: none	Thanks. I understand colon is reserved. That's why ":" was converted to "_" when saving the title in the filename. I would like to reverse the process and convert "_" to ":" when adding a book to my library.

08-23-2014, 01:57 PM	#4
kovidgoyal creator of calibre Posts: 45,639 Karma: 28549046 Join Date: Oct 2006 Location: Mumbai, India Device: Various	You cannot run regular expression on filenames while importing, you can run them in bulk via the search replace tab of the bulk metadata edit dialog, after importing.

08-23-2014, 02:15 PM	#5
comox Enthusiast Posts: 38 Karma: 10 Join Date: Jan 2011 Device: none	got it, thanks

Advert

Advert