So I created a user made column called version in which I would like the version info that is usually in the filenames of the books to be added:
Example: George RR Martin - Ice & Fire 1 - Game of Thrones (v5.0).epub
Is it possible to import the version info to the user created column and if so how?
When you go to the test field for import it doesn't seem to let you create a test field for it that I know of so that you can check if your work is correct or not.
This is what i tried and a few variations of:
^(?P<author>[^-]+)(\s*-\s*(\[?(?P<series>[^-0-9]+)\s*(?P<series_index>[0-9.]+)?]?)?)?.*?-\s*(?P<title>[^-]+)(\s*-\s*(\[?(?P<version>[^-]+)
with and with out a # sign in front of version.
so I don't know if the regex is incorrect and or it is or isn't possible to even import to user created columns.
I think it would be very useful in importing large collections with duplicates of titles indifferent versions to not strip the version info and have it go into its own column so you can out put it with or without. Its also great in combination with find duplicates with fuzzy logic... you can then get rid of old versions.
I have currently been importing them with:
^(?P<author>[^-]+)(\s*-\s*(\[?(?P<series>[^-0-9]+)\s*(?P<series_index>[0-9.]+)?]?)?)?.*?-\s*(?P<title>[^-]+)
so that it will import the version info as part of the title like so:
Author: George RR Martin
Title: Game of Thrones (v5.0)
Series: Ice & Fire
Series Index: 1
I stopped using this:
^(?P<author>[^-]+)(\s*-\s*(\[?(?P<series>[^-0-9]+)\s*(?P<series_index>[0-9.]+)?]?)?)?.*?-\s*(?P<title>[^\]{[()]+\w)
which strips all brackets including version info...
i prestrip all brackets other than version bracket info and clean up files with flash renamer pre-import to calibre.
The issue with having version info in the title is that when you go to get metadata it can throw it in to a loop and not recognize the title.
Does anyone else find this request useful for them as well? or would also like the ability to do that?
I do a lot of filename clean up in bulk with regex, wildcards and commands that can be stored and run in batch with
Opus and
Flash Renamer.
for example a file like this before running my batch command might look like this:
MCMARTIN, GeoRge R. R. - {Songs OF Fire & ICE 01] - a_game_of_THRONes [unabridged] (V5.1) {epub}.epub
will get fixed to this:
George RR McMartin - Songs of Fire & Ice 01 - A Game of Thrones (v5.1).epub
And i can run it against thousands of files at once.
Another useful tool is
ExtractNow which will bulk extract archives to their respective folder and subfolders to a folder of your choice including delete the archives after if you want without manually having to go into each folder/subfolder. Pretty useful for some downloaded collections.
If anyone is interested in any of the other software batch commands i have set up for them just pm me and ill be happy to help.
one other problem its a modification of what i'm using in a find and replace:
this is what im using:
INFO-----: Swap Lastname, Firstname if in front of a title or series with a dash(-)
EXAMPLE-: Carlin, George P - Stupid Jokes 1 - Your Mama!.epup
RESULT--: George P Carlin - Stupid Jokes 1 - Your Mama!.epub
FIND-----: ^(\w+), *([\w \.]+)[ ]+-[ ]*(.*)
REPLACE-: \2 \1 - \3
OR-------: (Depending on what program your using)
REPLACE-: $2 $1 - $3
But it won't work on file names that are like this:
Carlin, George P & Swift, Taylor L. L. - Stupid Jokes 1 - Your Mama!.epup
The intials could have periods. The file should end up looking like this.
George P Carlin & Taylor L. L. Swift - Stupid Jokes 1 - Your Mama!.epup
I need one that can do either both multi and single namess or a sepperate one that can handle multinames whichever is easier.
any ideas? Thanks for your time whoever solves the problem.