RockWorks | Datasheet | Columns | Fix
Use this RockWorks Datasheet program to strip out spaces and commas from numeric values in a column.
- Data Columns
- Input:
- 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.
- Options
- Decimals: Click on the Decimals item to specify the number of decimal places to be stored for the output numbers.
- Access the RockWorks Datasheet program tab.
- Open the datasheet to be manipulated.
- Click on the Columns menu above the datasheet and select the Fix option.
- Enter the requested menu options, described above.
- 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