Wish: Swap first name - surname at the selected records

Bug #923089 reported by Wolfgang Zeiger
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
calibre
Invalid
Undecided
Unassigned

Bug Description

It would be very nice if there would be a possibility to quick convert
selectet metadata between "surname, firstname" and "firstname surname" notation.
It costs a lot of time to sync a bigger amount of records to
the same format. Does'nt matter witch format one prefer.

Greetings and thanks from Germany
Wolfgang

Revision history for this message
Kovid Goyal (kovid) wrote : Re: calibre bug 923089

You can do this using the search and replace functionality in the bulk metadata
edit dialog (right click the edit metadata button to get this dialog).

 status invalid

Changed in calibre:
status: New → Invalid
Revision history for this message
Wolfgang Zeiger (wolfgang-zeiger1) wrote :

Thank you for fast response.
but at "search and replace" ist no option to switch between "surname, firstname" and "firstname surname" syntax.
If I import 400 books, half of them are recognized "surname, firstname" and the other ones "firstname surname".
To sync this to a unique type i have to edit 200 entrys manualy. "search and replace" would only helping if all of the
books is from the same author. But this is not the fact.

Its a similar problem/fix as the implemented switch autor <-> titele.

Greetings
Wolfgang

Revision history for this message
Kovid Goyal (kovid) wrote :

In the search field enter (\S+),\s+(\S+) and in the replace field enter \2 \1

Revision history for this message
Wolfgang Zeiger (wolfgang-zeiger1) wrote :

Thank you for response. I'am not familiar with regular expressions, but this one not works correct.
The author "Robb, J. D." will be converted to "J. Robb D." instead of "J. D. Robb".
Only a view people are familiar with regular expressions and I think if you could implement a otion like for switching artist<->title it would be usefull for many people.

So, and i also want to thank you very much for your great work witch calibre.

Greetings
Wolfgang

Revision history for this message
John (cwavontuur123) wrote :

I appreciate the answer given as it does solve a number of mismatches. And it seems we are close to a complete solution.

Original answer: In the search field enter (\S+),\s+(\S+) and in the replace field enter \2 \1

What needs to be added/changed to move all text behind the "", "" to the end of the field

So the author "Robb, J. D." will be converted to "J. D. Robb" instead of "J. Robb D.".

Bgds, John

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.