YES, IT WORKS VERY GOOD!
I just tried this one:
Code:
{author_sort:'contains($,",",strcat(uppercase(list_item($,0,",")),", ",list_item($,1,",")),uppercase($))'}
And I get:
- MADONNA
- HUXLEY, Aldous
So good!!! I couldnt even get to this point myself.
But now the only problem is when there is more than one author.
For example, with two authors:
When Author sort's metadata shows:
Smith, Sam & Dallas, Ken
...applying the code you gave me, comes up like:
SMITH, Sam & Dallas
For example, with more than two:
When Author sort's metadata shows:
Ronald, Alex & Chan, Liu & Tiffany, Megan
...applying the code you gave me, comes up like:
RONALD, Alex & Chan
It's weird, because it either omits the second author's first name, or also the other authors. I have tried other options, but it is going beyond my knowledge...
