Setting Data Format Options
Control the format of data values that are both displayed the Answerset window and Written to an Export file by setting options on the Data Format tab of the Options dialog box.
To set Data Format options
1 Select Tools > Options.
2 Click the Data Format tab. Table 21 explains each option.
Option |
Description |
Display dashes between bytes for binary data values |
When selected, a dash appears between each byte of the value for ease of reading, for example ‘63-B1-A3-62’. The default is selected. |
Write Byte Order Mark [BOM] to CLOB output files |
Select this option to add a Byte Order Mark at the start of each CLOB file. The default is cleared. |
Display BigInt and Decimal(16)+ values as strings |
When checked, large numeric values are stored as strings for Excel compatibility. The default is cleared. |
Display this string for Null data values |
Enter the string to be displayed in place of Null data fields in the reports and imported/exported files. The default for this setting is “?”. |
Display dates in this format |
The drop-down list contains pre-defined options to select. The characters d, m, and y to signify the day, month and year components can be added to the list. It also accepts /, -, ',' and space characters can be added as delimiters. |
Day formats are specified by repeating characters as follows: |
|
Month formats are specified by repeating characters as follows: |
|
Year formats are specified by repeating characters as follows: |
|
Insertion Characters: The dash, slash, comma, period and space characters are insertion characters. For example: Wheras d-mm displays 7-03 Note: Lowercase 'm' is automatically changed to uppercase 'M.' |
|
Number of decimal places to display for Float columns |
Entering a value between 0 and 9 allows you to specify the number of decimal places initially displayed for all data that originated from a FLOAT column. The default value for this option is 2. You can change the setting for selected columns. From the shortcut menu, choose Decimal Places. |
Handle Binary/Byte columns as BLOBs if size > |
Enter a number between 0 and 64000. The default value for this option is 30. Each BLOB is returned to a separate file on your PC. Regular Binary/Byte data appears in the grid as a hex string. |
Handle Varchar columns as CLOBs if size > |
This options allows you to set a size limit after which a Varchar column is handled as a CLOB. The default is 16384. |