Delimited String Sorter

Transforms a column containing delimited strings so that each of the strings have their elements sorted into either ascending or descending order. The output is into a new column with _sorted appended to the column name

e.g. if the input table were this:

Column1
bat, frog, car, astronaut
egg, cake, apple, banana

The resulting output (sorted) column would be

Column1_sorted
astronaut, bat, car, frog
apple, banana, cake, egg

The output delimiter and the input delimiter can be different.
If the string contains a delimiter of comma followed by space, as in the above example, you should specify comma and the space as the delimiter. otherwise the space is considered part of the data items and will result in a slightly mis-spaced resultant string

@takbb Brian Bates 19 July 2023

Input ports

1. Type: Table
   Input
   Data table containing at least one column with (unsorted) delimited strings

Output ports

1. Type: Table
   Ouptut
   Data table containing additional transformed column containing sorted delimited strings