Changing order of Name and Surname in Name tag

rolgiati · 07-11-2013, 08:38 AM

I get books from various sources, some have the name tag filled normally with "Name Surname" while others come with the name tag containing "Surname, Name".

Is there a simple way, using the metadata bulk edit, to re-order the contents of the name tag for those which are the wrong way round ?

And similarly, is there a simple way to change all the "NAME SURNAME" to "Name Surname" ?

rolgiati · 07-13-2013, 12:33 PM

Search books on author:"," and Select all.
Then go to Edit Metadata in Bulk, Search and Replace, choose the Search Mode: Regular Expression, the Search Field: Author, then input Search For: for (.*),(.*) and Replace With: \2 \1

It will still need some cleaning-up for those few
Authors who had more than one comma in the field...

BaconButty · 07-23-2013, 04:26 AM

Quote:

Originally Posted by rolgiati

Search books on author:"," and Select all.
Then go to Edit Metadata in Bulk, Search and Replace, choose the Search Mode: Regular Expression, the Search Field: Author, then input Search For: for (.*),(.*) and Replace With: \2 \1

It will still need some cleaning-up for those few
Authors who had more than one comma in the field...

This has helped me with 5000+ books!

rolgiati · 08-11-2013, 08:05 PM

And I found that for those books where the author is on the lines of :
name, first-name & other-name, other-first-name
The above recipe deals separately with each side of the & sign and properly returns
first-name name & other-first-name other-name

07-11-2013, 08:38 AM	#1
rolgiati Groupie Posts: 168 Karma: 31650 Join Date: May 2011 Location: Asuncion (Paraguay) Device: In the house, 3 K3 in use, 4 more in storage, and a K5 for testing	Changing order of Name and Surname in Name tag I get books from various sources, some have the name tag filled normally with "Name Surname" while others come with the name tag containing "Surname, Name". Is there a simple way, using the metadata bulk edit, to re-order the contents of the name tag for those which are the wrong way round ? And similarly, is there a simple way to change all the "NAME SURNAME" to "Name Surname" ? Last edited by rolgiati; 07-11-2013 at 10:37 AM. Reason: Incomplete

07-13-2013, 12:33 PM	#2
rolgiati Groupie Posts: 168 Karma: 31650 Join Date: May 2011 Location: Asuncion (Paraguay) Device: In the house, 3 K3 in use, 4 more in storage, and a K5 for testing	Solved ! Search books on author:"," and Select all. Then go to Edit Metadata in Bulk, Search and Replace, choose the Search Mode: Regular Expression, the Search Field: Author, then input Search For: for (.),(.) and Replace With: \2 \1 It will still need some cleaning-up for those few Authors who had more than one comma in the field...

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing sort order and title	jgt1942	Library Management	9	12-08-2023 03:47 PM
Tag browser categories order	Noughty	Library Management	11	08-17-2012 01:04 PM
Is There A Secret to Changing the Order Music Files Play In?	SteveEisenberg	Kindle Developer's Corner	7	10-18-2011 10:07 PM
Changing Book List Order	dreamvision	Library Management	5	02-08-2011 08:29 PM
Does changing PDF tag modifies file size	Giuseppe Chillem	Calibre	4	11-09-2010 10:47 AM

08-11-2013, 08:05 PM	#4
rolgiati Groupie Posts: 168 Karma: 31650 Join Date: May 2011 Location: Asuncion (Paraguay) Device: In the house, 3 K3 in use, 4 more in storage, and a K5 for testing	And I found that for those books where the author is on the lines of : name, first-name & other-name, other-first-name The above recipe deals separately with each side of the & sign and properly returns first-name name & other-first-name other-name

Advert