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 ?
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.
Retrieving data ...