View Single Post
Old 02-12-2012, 07:47 AM   #13
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 288
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
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?
transmitthis is offline   Reply With Quote