Step 5 - Setting base data formats
This step of the wizard provides a number of options for setting base formats for each source data file. The specified format should match the source data representation.
Separators
Decimal, Thousand, Date, Time
Decimal
Set a character to delimit the decimal parts of the imported numbers.
Thousand
Set a character to separate the digit groups in the imported numbers.
Date
Set a character to separate the year, month and day parts of date values.
Time
Set a character to separate the hour, minute and second parts of time values.
Constants
Boolean True
Set one or more variants of TRUE value representation in the imported table, e.g. 'Yes' or '+'. Use a new line for each additional variant.
Boolean False
Set one or more variants of FALSE value representation in the imported table, e.g. 'No' or '-'. Use a new line for each additional variant.
Null Values
Set one or more variants of NULL value representation in the imported table, e.g. 'Null'. Use a new line for each additional variant.
Date/Time formats
Use these edit fields to set the date and time formats: Date, Time.
For more information refer to the Format specifiers page.
Skip this step
Check this option to skip the current step in the future. To edit the list of skipped steps, use the Skipped Steps group available in the General section of the Preferences dialog.
When you are done, press the Next button to proceed to the next step.