Thread: Name and Surname
View Single Post
Old 03-19-2018, 01:01 PM   #3
kacir
Wizard
kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.
 
kacir's Avatar
 
Posts: 3,463
Karma: 10684861
Join Date: May 2006
Device: PocketBook 360, before it was Sony Reader, cassiopeia A-20
Quote:
Originally Posted by gianni_fed View Post
Hello,
someone know if there is a way to automatic invert the name and surname of selected one or more files already in Calibre?
For author in the format: Surename, Name
Select books
Right click
Edit metadata
Edit metadata in Bulk
Search and replace
Search field: authors
Search for: ([^,]*), (.*)
Replace with: \2 \1
Search mode: Regular expression

Check results in preview
Click OK

Do not forget to make backup of the library before experimenting with bulk search-and-replace of metadata using Regular Expressions.

Do not hesitate to ask if you need deeper explanation.
kacir is offline   Reply With Quote