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

Options

Descending (Reversed) Sort order

Leave de-selected for natural ascending sort order. Select for Descending (reversed) sort order

Choose columns containing delimited strings

Select all columns containing delimited strings to be sorted

Delimiter (include any space character that is part of the delimiter too)

Enter the delimiter (use \t for tab-delimited strings)%%00010%%00010If the string also contains space characters between elements, then include the space character as part of the delimiter, e.g. enter ", " rather than just "," as the delimiter. Otherwise the space character will be treated as part of the data element.

New Delimiter

Enter the new delimiter (use \t for tab-delimited strings)

Nodes

• String Configuration2 ×
• Boolean Configuration1 ×
• Column Filter Configuration1 ×
• Component Input1 ×
• Component Output1 ×
• String Manipulation (Multi Column)1 ×

Extensions

• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available