AnsweredAssumed Answered

How to sort alpha, when using List function

Question asked by vlight on Mar 29, 2013
Latest reply on Jun 3, 2014 by martionmaggot


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)