Selected Column AlphaNumeric Resorter

Similar to the Selected Column Resorter component, this returns the data table with the selected columns sorted in either ascending or descending alphabetical order, but in addition, pure numeric column names of up to 20 digits are sorted in numeric order, rather than alphabetic order. In an ascending sort sequence, pure numbers will appear first.

Note that any column containing anything other than purely numerics [0-9] will be treated as "alphabetic" and sorted accordingly.

The columns are then located positionally at the current position of the first of the selected columns alphabetically

For example, consider a table with the following columns:

A, D, X, W, B, Z, Y, 1,100,2,31

If columns X, Y Z,1, 100, 2 and 31 are to be sorted into descending order, the table would become

A, D, Z, Y, X, 100, 31, 2, 1 W, B

If only columns X, Y, Z, 1,100, 2 and 31 were to be sorted into ascending order, the table would become:

A,D,1,2,31,100,X,Y,Z,W,B

18 Nov 2021, based on original component May 2021 @takbb Brian Bates

Options

Select columns to be sorted alphabetically: Select columns to be sorted alphabetically. The columns will be grouped at the location of the first column in the selected group
Sort order: Specify the alphabetic sort order for the selected columns.%%00010%%00010Positive numeric integer column names of up to 20 digits will be sorted using numeric rather than text sort order. %%00010%%00010For ascending sorts,numerics will appear before alphas: 1,2,3,A,B,C%%00010For descending sorts, numerics will appear after alphas: C,B,A,3,2,1

Selected Column AlphaNumeric Resorter

Options

Input Ports

Output Ports

Nodes

Extensions

Links

Download