2019.1

Text file Input Data settings
Because text files have many different shapes and sizes, there are many options for the input
data in these files.
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 record, as defined by the Boundaries.
l
On lines: Triggers a new page in the Data Sample after a number of lines.
l
Cut on number of lines: Triggers a new page after the given number of lines.
With this number set to 1, and the Boundaries set to On delimiter, it is possible
to create a record for each and every line in the file.
l
Cut on FF: Triggers a new page after 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 data source.
l
Match case: Activates a case sensitive text comparison.
l
Location: Choose Selected area or Entire width to use the value of the
current data selection as the text value.
l
Left/Right: Use the spin buttons to set the start and stop columns to the
current data selection (Selected area) in the record.
Page 328