6.4.8.4.2 Import Wizard, The Data Pattern Page (Binary)

On this page, you define the structure of your binary file by specifying the order, type, and datum per record.

Data Pattern Page Binary.png

Pattern

Column

This column is not editable. It displays the column index numbers.

Type

Click and select the data type from the drop-down list (choices are Integer, Unsigned Integer, Real, and String).

Size

Once a data type is chosen, the Size column is automatically filled with typical size for that type (except for string, in which case it is left blank). The Size column text is editable. For instance, the default length for Int is 4, but you can replace this with 2 if you want a Short Int. For strings, you should specify the length in characters.

Count

Use the Count column to specify the number of times data columns of this variable type are repeated in the record.

Insert

Rows are automatically added as you define your data structure. Click this button to add a row.

Delete

Rows are automatically added as you define your data structure. Click this button to remove a row.

Data View

Hex

Select this radio button if you want to view the data in byte form.

ASCII

Select this radio button if you want to view the data in ASCII form.

Preview Pane

When a (row of) structure definition is completed, the preview pane displays the imported data as it will look in the resulting worksheet, based on the structure of the record specified thus far. Note that you can right-click on the column headers in the bottom panel to set the Designation and Format for the columns in the target worksheet.

Keep Target Column Format: Use this check box to specify whether to keep target column format. If this check box is selected, the Set Format short-cut menu, which pops up when you right-click on the column header in the preview window, will have no effect.

Set format.png