1 Reply Latest reply on May 13, 2014 9:11 AM by philmodjunk

    Sorting in a text field



      Sorting in a text field


           I have up to 10 comma separated text strings in a single text field, like:  Mac,Apple,Mouse,Trackpad,Printer,

           Is there any sleek way to sort these alphabetically ?





        • 1. Re: Sorting in a text field

               Yes, put then in fields of a set of related records, Then sorting them becomes simply a matter of sorting the records alphabetically.

               A simple calculation field can still display the sorted results in your comma separated list format--provided that you specify this sort order in the relationship.