Fixing Columns

RockWorks | Utilities | Columns | Fix

Use this RockWorks Utilities program to strip out spaces and commas from numeric values in a column. 

Menu Options

• Input Columns:
  • Start: Click on this item to select from the drop-down list the name of the first column in the current data sheet that contains the original data to be stripped of non-numeric characters. 
  • End: Click on this item to select from the drop-down list the name of the last column in the current datasheet into which the "fixed" numbers are to be listed. Any columns between the Start and End columns will also be fixed.
• Decimals: Click on the Decimals item to specify the number of decimal places to be stored for the output numbers.

Step-by-Step Summary

1. Access the RockWorks Utilities program tab.
2. Open the datasheet to be manipulated. 
3. Click on the Columns menu above the datasheet and select the Fix option. 
4. Enter the requested menu options, described above.
5. Click the Process button to proceed.

The program will remove commas and spaces from the source values, storing the results in the designated output column.

Back to Editing the Datasheet

RockWare home page