Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 09-19-2012, 09:24 AM   #1
djeaton
Junior Member
djeaton began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Jan 2012
Device: Kindle Fire
Question Author sort question

I have about 200 books in my library where the author and author sort are both in the Lname, Fname format. What is the easiest way to convert author to Fname Lname format? I *imagine* I could do the same thing stripping out publication dates or series names/numbers from titles. If possible, I'd love to be able to do this without writing out the data and re-importing, but would ultimately like to learn how to do this both with metadata manipulation when saving to disk AND some "internal" process. I just can't wrap my head around the coding for parsing out pieces of text and re-ordering them.
djeaton is offline   Reply With Quote
Old 09-19-2012, 09:56 AM   #2
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,291
Karma: 6022733
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by djeaton View Post
I have about 200 books in my library where the author and author sort are both in the Lname, Fname format. What is the easiest way to convert author to Fname Lname format? I *imagine* I could do the same thing stripping out publication dates or series names/numbers from titles. If possible, I'd love to be able to do this without writing out the data and re-importing, but would ultimately like to learn how to do this both with metadata manipulation when saving to disk AND some "internal" process. I just can't wrap my head around the coding for parsing out pieces of text and re-ordering them.
Install and Use the Quality Check Plugin
theducks is online now   Reply With Quote
Old 09-19-2012, 10:14 AM   #3
djeaton
Junior Member
djeaton began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Jan 2012
Device: Kindle Fire
Thumbs up

Quote:
Originally Posted by theducks View Post
Install and Use the Quality Check Plugin
I'll have to check that out. Thanks! That is probably the easiest thing. I'd still like to understand the coding syntax though. I think I'm going to need to know this to clean up some of the series that I have that have a ton of extra stuff added to the title.
djeaton is offline   Reply With Quote
Old 09-19-2012, 10:18 AM   #4
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,291
Karma: 6022733
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by djeaton View Post
I'll have to check that out. Thanks! That is probably the easiest thing. I'd still like to understand the coding syntax though. I think I'm going to need to know this to clean up some of the series that I have that have a ton of extra stuff added to the title.
The QC PI will help identify those.
Bulk Metadata edit has a powerful Search and Replace (can be with nothing ) .Look for the Tab at the top of the Edit form dialog box
theducks is online now   Reply With Quote
Old 09-19-2012, 10:54 AM   #5
djeaton
Junior Member
djeaton began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Jan 2012
Device: Kindle Fire
Quote:
Originally Posted by theducks View Post
The QC PI will help identify those.
Bulk Metadata edit has a powerful Search and Replace (can be with nothing ) .Look for the Tab at the top of the Edit form dialog box
That tells me WHERE to put in the code, but I don't know what code to put in.

BTW, LOVE your cat. We have a new rescue kitty that looks just like that!
djeaton is offline   Reply With Quote
Old 09-19-2012, 11:04 AM   #6
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,291
Karma: 6022733
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by djeaton View Post
That tells me WHERE to put in the code, but I don't know what code to put in.

BTW, LOVE your cat. We have a new rescue kitty that looks just like that!
Ellie (the cali-meese) and her brother is from one of the local Adopt a cat shelters, Carmella (AKA Bounce) was adopted from the Animal Services shelter. Noni (and Fanci RIP) was Adopted from our old Vet. Meaghan our Corgi is also a Rescue animal.

Back on topic
There is No magic entry.
This is very powerful and as you will note in The red NOTE: can do great harm, very quickly

Each needs to be hand crafted. If you have done it right, you will see your desired results in the test area.

Learn REGEX., it can pick apart just about anything.
There was a REGEX thread over a Year ago by Manichean that should help get you going
theducks is online now   Reply With Quote
Old 09-19-2012, 11:46 AM   #7
djeaton
Junior Member
djeaton began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Jan 2012
Device: Kindle Fire
I read the regex stuff in the calibre manual, but it didn't do much for me. I don't know what the different parts of the expression mean or do. So I can copy examples from here or there to do things like add series and sort order to title when I send books to my reader, but knowing that X expression does something doesn't help me understand all the parts of the expression in case I want to change it much more than to have my series order a 2-digit number versus a 3-digit one. I'll see what I can find though.

And just for grins, here's "Rambo". He's about 10 weeks old or so.
djeaton is offline   Reply With Quote
Old 09-19-2012, 12:03 PM   #8
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,291
Karma: 6022733
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
There is different forms of REGEX used in different places.
The Add books template is (almost) nothing like the REGEX used in the Metadata S&R Which is nothing like the Save/Send to template
BTW Calibre stores series_index as Real numbers internally, not as a string.


This is the one I suggested http://www.mobileread.com/forums/sho...ighlight=REGEX
It is useful in S&R (and the Sigil EPUB editor)

Neat cat (A meese, the best kind )
theducks is online now   Reply With Quote
Old 09-19-2012, 12:03 PM   #9
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,055
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
Quote:
Originally Posted by djeaton View Post
That tells me WHERE to put in the code, but I don't know what code to put in.
For swapping LN, FN or FN LN in Authors, see Regex "FN LN" to "LN, FN" & reverse, posts #4 and #5.

Using Quality Check plugin as theducks said is easier and faster.

Last edited by unboggling; 09-19-2012 at 12:06 PM.
unboggling is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
bulk replacement Author(s) from Author sort Brocklage Library Management 1 08-10-2012 04:41 PM
Another author sort question retro Library Management 4 06-02-2012 09:37 PM
using author sort for author - Sony 950 Purple Lady Devices 2 01-29-2011 01:23 AM
Question about author sort and requests lisa.m Calibre 2 07-06-2009 12:15 PM
Author(s) & Author Sort BobF Calibre 11 01-02-2009 06:01 PM


All times are GMT -4. The time now is 12:27 PM.


MobileRead.com is a privately owned, operated and funded community.