1.4

l
Paragraph spacing: Determines the spacing between paragraphs. The default value is
1.5, meaning the space between paragraphs must be equal to at least 1.5 times the
height of the average character height to start a new paragraph.
l
Magic number: Determines the tolerance factor for all the above values. The tolerance is
meant to avoid rounding errors. If two values are more than 70% away from each other
they are considered distinct, otherwise they are the same. For example, if two characters
have a space of exactly one times the width of the average character, we actually
consider any space of between ".7" and "1.43" this average width equals to one space. A
space of 1.44 is considered to be 2 spaces.
l
PDF file color space: Determines if the PDF if displayed in Color or Monochrome in the
Data Viewer. Monochrome display is faster in the Data Viewer, but this has no influence
on actual data extraction or the data mapping performance.
For Databases
The following settings apply to any database and ODBC Data Sample.
l
Connection String: Displays the connection string used to access the Data Source.
l
Table: Displays the tables and stored procedures available in the database. The selected
table is the one the data is extracted from.
l
Encoding: Defines what encoding is used to read the Data Source (US-ASCII, ISO-
8859-1, UTF-8, UTF-16, UTF-16BE or UTF-16LE ).
l
Browse button : Opens the Edit Database configuration dialog, which can replace
the existing database data source with a new one. This is the same as using the Replace
feature in the Data Samples window.
l
Custom SQL button : Click to open the SQL Query Designer and type in a custom SQL
query.
For a Text File
l
Encoding: Defines what encoding is used to read the Data Source (US-ASCII, ISO-
8859-1, UTF-8, UTF-16, UTF-16BE or UTF-16LE ).
l
Add/Remove characters: Defines the number of characters to add to, or remove from,
the head of the data stream. The spin buttons can also increment or decrement the value.
Positive values add blank characters while negative values remove characters.
l
Add/Remove lines: Defines the number of lines to add to, or remove from, the head of
the data stream. The spin buttons can also increment or decrement the value. Positive
values add blank lines while negative values remove lines.
l
Maximum line length: Defines the number of columns in a data page. The spin buttons
can also increment or decrement the value. The maximum value for this option is 65,535
characters. The default value is 80 characters. You should tune this value to the longest
Page 116