1.5

l
Custom SQL button : Click to open the SQL Query Designer and type in a custom SQL
query.
For a Text File
Because text files have many different shapes and sizes, there are a lot more options for the
input data in these files. You can add or remove characters in lines if you have a big header
you want to get rid of, or really weird characters at the beginning of your file. Set a line width if
you are still working with old line printer data and so on. It is still important, however, that pages
are defined properly. This can be done either by using a set number of lines or using the “P”
character - or if your data is a bit more complex, to detect text on the page. Be careful that these
are not Boundary settings but rather page settings in order to make sure you are configuring
these options to detect each new page and not each new Source Record.
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 Selection/Text is based on bytes:Check for text files that use double-bytes characters
(resolves width issues in some text files).
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 on 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
line in your input data. Setting a maximum data line length that greatly exceeds the length
of the longest line in your input data may increase execution time.
l
Page delimiter type: Defines the delimiter between each page of data. Multiples of such
pages can be part of a Source Record, as defined by the Boundaries.
l
On lines: Triggers a new page in the Data Sample after a static number of lines
(called Lines per Page), or using a Form Feed character.
l
On text: Triggers a new page in the Data Sample when a specific string is found in
a certain location.
l
Word to find: Compares the text value with the value in the Source Record.
l
Match case: Activates a case-sensitive text comparison.
Page 141