MobileRead Forums - View Single Post - Have a Regular Expression problem with Author Field

searcygr · 09-20-2018, 10:48 PM

So, my son imported books into his Calibre library (using the latest version 3.31.0) and the Title was split across the title and author fields. For example: Vamps (Title) and Hollywood & Vein 01 (Author).

I am trying to use the Bulk Metadata Search/Replace to fix the problem. There are 800+ books that are affected and only the & in the title is causing a real problem.

In Search and replace Tab, I have the following:

Search Field: authors
Search For: ([A-Za-z\s\&].*)
Replace with: " \1" -- preceeding space required to display result properly with spaces
Destination field: title
Mode: Append to field
Split result (unchecked)
Values starting at 1 with values separated by :::

Book 1: Hollywood:::Vein 01 yields a test result of Vamps Hollywood Vein 01

Any ideas on what the Search for: should be (regular expression) to yield a
test result of Vamps Hollywood & Vein 01
???

Thanks in advance.

09-20-2018, 10:48 PM	#1
searcygr Junior Member Posts: 6 Karma: 10 Join Date: Aug 2018 Device: none	Have a Regular Expression problem with Author Field So, my son imported books into his Calibre library (using the latest version 3.31.0) and the Title was split across the title and author fields. For example: Vamps (Title) and Hollywood & Vein 01 (Author). I am trying to use the Bulk Metadata Search/Replace to fix the problem. There are 800+ books that are affected and only the & in the title is causing a real problem. In Search and replace Tab, I have the following: Search Field: authors Search For: ([A-Za-z\s\&].*) Replace with: " \1" -- preceeding space required to display result properly with spaces Destination field: title Mode: Append to field Split result (unchecked) Values starting at 1 with values separated by ::: Book 1: Hollywood:::Vein 01 yields a test result of Vamps Hollywood Vein 01 Any ideas on what the Search for: should be (regular expression) to yield a test result of Vamps Hollywood & Vein 01 ??? Thanks in advance.