Sort DAT

Summary

The Sort DAT will sort table DAT data by row or column.

Parameters

Sort /sortmethod - Determines how the table will be sorted.

• Rows (Specify Column Name) - Sort rows using the column specified under the Name parameter.
• Rows (Specify Column Index) - Sort rows using the column specified under the Index parameter.
• Columns (Specify Row Name) - Sort columns using the row specified under the Name parameter.
• Columns (Specify Row Index) - Sort columns using the row specified under the Index parameter.

Name /sortname - When using Sort Specify Row/Column Name, specify the name in this parameter. If the sort name does not find a match, the output will be unsorted.

Index /sortindex - When using Sort Specify Row/Column Index, specify the index in this parameter. If the sort index is -1 or out of bounds, the output will be unsorted.

Sort Order /numeric - Determines the type of sorting.

• Alphabetical - Use alphabetical sorting. Numbers are treated as characters, sorted by their ASCII values.
• Alphabetical with Numbers - Use alphanumerical sorting.
• Numbers - Use numerical sorting. Characters are all treated as 0, incoming order is preserved.

Reverse Output /reverse - Reverses the sort order.

Unique Output /unique - remove duplicate rows/column entries in the sorted row/column.

Ignore Case /ignorecase - ignores case sensitivity when Sort Order is set to Alphabetical or Alphabetical with Numbers.