How to sort alpha, when using List function
In FM11, when i use the List function, can i alphabetize the resulting list of values? If so, how? Right now, it's just giving me the list based on the order in which the values were chosen.
specifically, i have a calc field where i am not only using the List function but also the substitute function on the list it creates, substituting the paragraph return for a dash (so i can see the list of values horizontally, as below... )
Substitute ( List ( TargetField ) ; paragraph return character ; "-" )
(Sorry, i'm on an iPad and couldnt actually type the pilcrow character in the calc above)