Sorry to dig this up, but I have the same issue at present.
I really would like to be able to sort my library by file length
(Having issues with about 50books that are two long in their path length)
If a file name column, or a way to sort the library by lenght of title then I could easily find and edit those files.
As it is I'm left with creating a file list in windows (dir /b /s > c:\filelist.txt) and importing to Excel, then a "len" formula and sort, will get me a sorted list - but that still leaves me with a time consuming way to find and edit the files in Calibre.
Anyone had anymore thoughts on this.
Regarding another way to do what I want:
If anyone can help me with a Reg Expression in the search and replace metadata editing.
It seems all of my too long files are because of titles that include, sub titles ie
Here Comes Civilization: The Complete Science Fiction of William Tenn Volume II
Obviously that makes a long file name - even in the root of C:\
C:\14ThousandBooks\William Tenn\Here Comes Civilization: The Complete Science Fiction of William Tenn Volume II (10166)\Here Comes Civilization: The Complete
Science Fiction of William Tenn Volume II - William Tenn.mobi
All I need is a Reg Expression to search for ": " colon and space and any subsequent text and replace with nothing, I did try but Python is not my thing. Any takers?
|