I’ve been asked a few questions about this one, so here is a tutorial that walks through the process step by step. The app I’m working on in the tutorial is copyable, so feel free to make your own copy (see link below).
If you convert it to an array using a Split Text column (or just aquire it using a Lookup instead of a Joined List), then you can use the Sort Array plugin to sort it. Then you can convert that sorted array back to a Joined List.
hmm, I’m not so sure about this. The Sort Array plugin just does a simple sort, whereas in this case a slightly more complex sort is required. That is, we are using a secondary array as the sort keys for the primary array. I don’t think this is possible with the plugin, but quite possibly I’m missing something?