Sorting Data

RockWorks | Utilities | Rows | Sort Rows
Right-click | Sort Rows

This program is used to sort the contents of the current file displayed in the RockWorks Utilities datasheet, based on up to three data columns and sorting parameters you select. The sorted data will be displayed in the same datasheet.

Menu Options
Step-by-Step Summary

Menu Options

• Input Columns: The prompts along the left side of the window tell RockWorks which columns in the datasheet contain the input data.
  • Sort Column 1: Select the column in the datasheet upon which the sorting process is to be done. For example, if you wanted to sort the rows based on the entries in the ID column, you would select ID here.
  • Sort Column 2: If you wish to invoke a secondary sort, activated below, choose the column containing that data.
  • Sort Column 3: If you wish to invoke a third-level sort, activated below, choose the column containing that data.
• Sort Column 1:
  • Data Type: Click in the appropriate radio button to tell the program whether the column you selected is a numeric column or alphanumeric (text) column.
  • Sort Order: Click on the appropriate button to define how the information in the selected column is to be sorted.
• Sort Column 2: Insert a check here if you want to perform a secondary sort based on the Column 2 you defined above.
  • Data Type: Click in the appropriate radio button to define whether the input column is a numeric column or alphanumeric (text) column.
  • Sort Order: Choose Ascending or Descending for the order.
• Sort Column 3: Insert a check here if you want to perform a third-level sort based on the Column 3 you defined above.
  • Data Type: Define the input data as numeric or alphanumeric (text).
  • Sort Order: Choose Ascending or Descending for the order.

Step-by-Step Summary

1. Access the RockWorks Utilities program tab.
2. Open the Utilities datasheet to be manipulated.
3. Click on the Rows menu above the datasheet and select the Sort Rows option. Or, right-click in the body of the datasheet and select Sort Rows.
4. Enter the sort parameters, described above.
5. Click the Process button at the bottom of the window to continue.

The program will sort the rows in the current datasheet based on the ascending or descending order of the data in the column you selected. 

Back to Editing the Datasheet

RockWare home page