Thanks for the reply, but that's not what I meant
My question comes after I read glynor's answers in the topic: Sort Artist by Family Name
https://yabb.jriver.com/interact/index.php?topic=104077.0Currently if I order the [artist] column from a to z I get:
-----------------------
Artist (a-z)
-----------------------
Paul Young
Pink Floyd
Stevie Wonder
Talking Heads
Whitney Houston
and there is no way to sort the name of bands and surnames of persons
I think it would be nice if in future jriver would be able to order the [Artist] column in this way from a to z:
-------------------------------------------------------
Artist (a-z) | Artist Swap Toggle
------------------------------------------------------
Whitney
Houston 0
Pink Floyd 1
Talking Heads 1
Stevie
Wonder 0
word_a word_b 1
word_a
word_b 0
Paul
Young 0
[Artist Swap Toggle] with value 0 -> first word
[Artist Swap Toggle] with value 1 -> Second word (after space)
Therefore I would like to use only one field called [Artist Swap Switching] which allows jriver to know which of the two words should be used in alphabetical order (if the first or second word which appears in the [Artist] field).
In this way I do not have to add another field with the swap function, where the name of the artist appears inverted (word_b word_a)
Do you think this will be possible in the next versions of jriver?
If I use your function
if(isequal([Artist Swap Toggle], 0),removecharacters(swap([artist]),/,,0),) I get:
-------------------------------------------------- --------------------------
Artist Swap Toggle My field (a-z)
-------------------------------------------------- --------------------------
Whitney Houston 0 Houston Whitney
Stevie Wonder 0 Wonder Stevie
Paul Young 0 Young Paul
Pink Floyd 1
Talking Heads 1
The value 1 does not return any name
I hope my question is clearer and thanks for the support.