How to bulk replace author - book name

[alophind]

Hi ,
In all the books I import , calibre put the author as book title and book title as author .

is there a way to bulk replace all ?

[DoctorOhh]

Originally Posted by alophind

Hi ,
In all the books I import , calibre put the author as book title and book title as author .

You can select all the books you wish to swap and choose Edit Metadata, check swap title and author box then click ok and all titles and authors for the books selected will be swapped.

Alternatively you can try to get the info correct to begin with. Calibre tries to get the info from metadata but if that fails it uses the regular expression under Preferences - Adding books to extract info from the file name.

Try this regex

^((?P<title>([^\-_0-9]+)(?=\s*-\s*)(?!\s*-\s*[0-9.]+)|\b))(\s*-\s*)?((?P<series>[^0-9\-]+)(\s*-\s*)?(?P<series_index>[0-9.]+)\s*-\s*)?(?P<author>[^\-_0-9]+)

or this one

^((?P<author>([^\-_0-9]+)(?=\s*-\s*)(?!\s*-\s*[0-9.]+)|\b))(\s*-\s*)?((?P<series>[^0-9\-]+)(\s*-\s*)?(?P<series_index>[0-9.]+)\s*-\s*)?(?P<title>[^\-_0-9]+)

After entering either put a file you would like to add including the epub or mobi extension in the test window and test it to see what is populated. I didn't write either but one or the other usually works for me.

[alophind]

Originally Posted by dwanthny

You can select all the books you wish to swap and choose Edit Metadata, check swap title and author box then click ok and all titles and authors for the books selected will be swapped.

Alternatively you can try to get the info correct to begin with. Calibre tries to get the info from metadata but if that fails it uses the regular expression under Preferences - Adding books to extract info from the file name.

Try this regex

^((?P<title>([^\-_0-9]+)(?=\s*-\s*)(?!\s*-\s*[0-9.]+)|\b))(\s*-\s*)?((?P<series>[^0-9\-]+)(\s*-\s*)?(?P<series_index>[0-9.]+)\s*-\s*)?(?P<author>[^\-_0-9]+)

or this one

^((?P<author>([^\-_0-9]+)(?=\s*-\s*)(?!\s*-\s*[0-9.]+)|\b))(\s*-\s*)?((?P<series>[^0-9\-]+)(\s*-\s*)?(?P<series_index>[0-9.]+)\s*-\s*)?(?P<title>[^\-_0-9]+)

After entering either put a file you would like to add including the epub or mobi extension in the test window and test it to see what is populated. I didn't write either but one or the other usually works for me.

I needed the second one.
Thank you very much !!!