Black Box ICOMP, User Manual

Page: 24 / 92

Copyright (c) 2009 - 2012 Black Box Corporation
724-746-5500 | blackbox.com 24
iCompel Data Engine - User Guide (V3.1.2)
Use existing schema information file . This setting will use the settings present in the file
schema.ini
contained in the same folder as the source file, and current registry settings to determine how the source file
should be processed.
Note this option is only available for local files.
Specifying a Separator Delimiter Character
The Separator option specifies if a tab or comma should be treated as the value delimiter.
Specifying Column Headings
The Column headings entry indicates how the iCompel Data Engine should detect column headings in the data.
The following options are available:
First row contains column headings . The first row in the source data contains column headings.
No column headings are present . No column headings are present. All rows in the source contain data
values.
Specifying Date and Time Format
This entry specifies the mask used to process date and time values. The following notation is used:
d, dd = day; ddd, dddd = day of week, M = month, yy, yyyy = year
hh = hour, nn = minute, ss = second
Number Formatting
By default, a period symbol is assumed for number and currency separators. These can be modified by using
custom schema information settings.