Rename and sort

[frankenfrank]

First, sorry about my bad English.

In my Calibre Collection i have many books in these format

king.stephen.-.the.stand

this information is completely in the title section.

I want the following format

Title section: The Stand
Author: Stephen King

How can i do this?

Thx 4 help

[theducks]

There are periods in the title. FUN (dot is a wildcard in REGEX and must be escaped)

First OFF. this BULK MODE EDIT Search and Replace

My REGEX pattern only works for your books that are Exactly the same as shown
VERIFY in the TEST results before committing (and Keep a backup)

Learn REGEX Basics, it will serve you well There are a couple of good REGEX tutorials (Pablo and Manichean)

king.stephen.-.the.stand

Step 1: Copy (prior to Remove) the Author
Search field Title:
Search for (.+)\.(.+)\.-\.(.+)
Replace with \2 \1 << flips the order with a space
Apply Function (on right) Titlecase
Destination field Author

You need a different pattern set for Author with Initials, Generations or Titles

Once the Author FIELD is done, we need to clean the title

Same Search field and term
Destination field is Title
Replace With \3 <everything past the .-.
Why not take care of the Case at this using the SAME as above?


From here on, The Title cleanup requires unique solutions

[frankenfrank]

Hello Theducks,

great, thank you very much. It Works.

The only Think is, the surname of the author is not in capital letter. by the way. I am happy. Thx.

[frankenfrank]

Oh, i got the complete solution.

The Option Function to replace set on the last option.