Author sort question

djeaton · 09-19-2012, 08:24 AM

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.

theducks · 09-19-2012, 08:56 AM

Quote:

Originally Posted by djeaton

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

djeaton · 09-19-2012, 09:14 AM

Quote:

Originally Posted by theducks

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.

theducks · 09-19-2012, 09:18 AM

Quote:

Originally Posted by djeaton

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

djeaton · 09-19-2012, 09:54 AM

Quote:

Originally Posted by theducks

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!

theducks · 09-19-2012, 10:04 AM

Quote:

Originally Posted by djeaton

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

djeaton · 09-19-2012, 10:46 AM

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.

theducks · 09-19-2012, 11:03 AM

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 https://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

)

unboggling · 09-19-2012, 11:03 AM

Quote:

Originally Posted by djeaton

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.

09-19-2012, 08:24 AM	#1
djeaton Junior Member Posts: 8 Karma: 10 Join Date: Jan 2012 Device: Kindle Fire	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.

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

09-19-2012, 10:46 AM	#7
djeaton Junior Member 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.

09-19-2012, 11:03 AM	#8
theducks Well trained by Cats Posts: 29,799 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	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 https://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 )

Advert

Advert