Edit Fields

On the File | File Editor tab, in the Edit Fields group:

• Click Sort to sort records using one or more fields as the keys, and store the result in the same or a different file. You can sort records in ascending or descending order, based upon the values in the fields you specify.

• Click Calculate (Expression) to perform expression calculations and write the results to new fields in the current file. If more than one file is open, the expression calculation is performed on the file in the active window.

• Select Calculate to perform field calculations and write the results to new fields in the current file. A broad range of functions are provided for field calculations. If more than one file is open, the calculations are performed on the file in the active window.

• Click Validate to compare the values in a selected field against a list of permitted values entered in a Check file. A Check file must be created before this function can be run.

These options are also available on the File | Lookup Table Editor tab, in the Edit Fields group for Lookup Tables.