Download Description

§2 Data Entry
c
Figure 2.9: Delete all rows with empty cells. (a) Original data with empty cells; (b) Missing Data
window displays all rows with empty cells (missing data); (c) Modified data table (five rows were
deleted).
Delete all columns with empty cells. This function enables to detect all columns
with empty cells (at least one missing entry in a column) and to delete them. By
choosing this option the Missing Data window will be opened to display all the
columns with at least one empty cell. Click Yes in order to proceed and to get the
modified data (see Fig. 2.9 for rows).
Fill all empty cells with. This function allows to fill in all the empty cells with a
specific value. Once chosen, the Fill Empty Cells window will be opened (Fig. 2.10).
Insert a valid value in the field "Load empty cells with". Once clicking OK, all the
empty cells in the grid will be filled with this value.
Figure 2.10: Fill Empty Cells window. Value 3 is inserted in the field "Load empty cells with". All
empty cells in the grid will be filled with 3.
Delete all rows with incomplete code. This function is available only when
using the Octal data and Hexadecimal data. It allows deleting all rows with
incomplete codes. (Incomplete code is the Octal or Hexadecimal Code with the code
length shorter than declared in the Data Parameters window (Fig. 2.12) in the case of
Enter New Data, or shorter than code of maximum length in the case of Open
20