[Bigo2]

I am trying everything what was said here about the Author(s) sort - the order of the First Name and the Second Name (or Christian Name and Surname if you like) but cannot find the solution...

But first, I have to say that I do not understand why any programmer would even think about organizing people’s names database in any other way than the SURNAME first…

I understand that the default Author(s) column is alphabetized according to the surname, you just have to look the last word on the line, but it seems to me pretty odd…

So I am asking again: I want to start with copying aver 1000 books from a folder on my PC (win7 64bit) – they are all in one folder and mostly have the following format:

Altered Humans - Darrell Bain
Assassin's apprentice - Robin Hobb
Dolan's Cadillac - Stephen King
or
Doctor Zhivago - Boris Leonidovich Pasternak
Distant Galaxies Colliding - Gareth L. Powell
Familiar Pattern - A. Bertram Chandler
Poor Henry - E. C. Tubb

these are most common, but some of them are stored like this (I suppose those would be probably easier for my purpose):

All Together Dead - Harris, Charlaine
And Then There Were None – Christie, Agatha
or
Fahrenheit 451 - Bradbury_ Ray
Ender in Exile - Card_ Orson Scott

however, some are like this, not many, and I suppose they can be changed manually:

Dune - House Harkonnen - Brian Herbert & Kevin J. Anderson & Frank Herbert

My requirement is, that the Calibre Library file structure created on my PC should look like this:
e.g.

M:\Calibre Library\Bain, Darrell\Altered Humans (####)\
M:\Calibre Library\Hobb, Robin\Assasin’s apprentice (####)\
M:\Calibre Library\Pasternak, Boris Leonidovich\Doctor Zhivago\
M:\Calibre Library\Tub, E. C.\Poor Henry (####)\

The same name order should be in the Calibre main window for the “Author(s)” column

Could you please let me know what to do to be able transfer these mixed files from my source and get most of the Calibre Library on my PC as well as in the Calibre program sorted out according to my requirement? I mean, is there any universal algorithm or tweak which can be applied to get (mostly) as I require?

Thanks George