You can only perform this action with indexed files, where you can order the records by any of the keys configured when the
data file was created.
Micro Focus Data File Tools window, click
, or click
Open dialog box appears.
Navigate to the required data file, then click
Open Data File dialog box appears.
If you are applying a record layout, click
Browse to the right of the
Structure File (optional) field, then use the
Open dialog box to navigate to and select the structure (.str) file that contains the layout.
Open Shared (to open the file in read-only mode) or
Open Exclusive (to open the file in edit mode).
The file is displayed on its own tab in the main window.
To order from the currently selected record, click
Primary Key, then select an alternate key to order your data file by.
The data file is ordered (ascending order) using the key value.
Note: The ordering starts at the currently selected record. For example, if you have the fifth record in a list selected when you
sort on a different key, that record will remain fifth in the list, and the sixth record onwards will be sorted, in ascending
order, using the key value. There will also be four records before the current record, which will be sorted in descending
order using the key value. This may mean that not all records from the data file are displayed.
To order based on a particular value (without having to select the record containing that value):
beside the key name.
Go to :<key-name> dialog box appears.
Type the value on which to search, then click
Note: If you select a split key, type the required value(s) in the relevant component boxes.
The data file is ordered (ascending order) using the key value(s).
To re-display the original order of the data file, click
, which is displayed just above the records, on the left-hand side.