I want to create a composersort field that sorts by composer's last name.
The information is in the composer field and I want to transpose first and last names and copy them to the composersort field. In other words,
field composer --- James Joyce
field composer sort -- Joyce, James
The post below is sort of the reverse of what I want to do, but I don't know enough about the expressions to adapt it to my need.