[DoctorOhh]

Originally Posted by Lauraq

I do not think that it is as you say because in the faq site I have read about commands that should not put the comma (but don't work for me)

The no comma tweak is used to copy the author column to the author_sort column. Not the other way around. I'm fairly sure you don't want you Author column to be LN FN and your Author_sort column to be FN LN (without a comma), sorting by first name would be very counter-intuitive.

Below is the full tweak info.

Spoiler:

ID: author_sort_copy_method

The algorithm used to copy author to author_sort
Possible values are:
invert: use "fn ln" -> "ln, fn"
copy : copy author to author_sort without modification
comma : use 'copy' if there is a ',' in the name, otherwise use 'invert'
nocomma : "fn ln" -> "ln fn" (without the comma)
When this tweak is changed, the author_sort values stored with each author
must be recomputed by right-clicking on an author in the left-hand tags pane,
selecting 'manage authors', and pressing 'Recalculate all author sort values'.
The author name suffixes are words that are ignored when they occur at the
end of an author name. The case of the suffix is ignored and trailing
periods are automatically handled. The same is true for prefixes.
The author name copy words are a set of words which if they occur in an
author name cause the automatically generated author sort string to be
identical to the author name. This means that the sort for a string like Acme
Inc. will be Acme Inc. instead of Inc., Acme

Originally Posted by Lauraq

then they also know that many person do not want the comma.

This is not correct, you are the first person in over 4 years of reviewing this forum that I can recall ever having an obsession about the comma in the actual author column.

chaley, one the main contributors to calibre's code answered your question here.

Originally Posted by chaley

If you do not use commas then there is no way for calibre to guess what order an author's name is in. "John Doe" and "Doe John" look exactly the same. As a result, things like the quality check plugin and search/replace are probably of no help to you.

Just for a point of reference, here is the section of the FAQ that covers switching FN LN in the author column to LN, FN. If it isn't clear in this section how to accomplish what you want it is because what you want is not a Frequently Asked Question.

However, as Adoby points out above you can do what you want with the tweak above using the copy option. Then make sure that each entry in the author column is LN FN. Select all and in edit metadata select Automatically set author sort.

Good Luck.