2018.1

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.
l
Lines before/after: This option places the delimiter a certain number of lines
before or after the current line. This is useful if the text that triggers the
delimiter is not on the first line of each page.
l
Text from right to left: Sets the writing direction of the data source to right-to-left.
l
Expand tabs to spaces: Replaces tabs with the given number of spaces.
l
Ignore CR/LF at end of file: Instructs the DataMapper to ignore the CR, LF or CR/LF
characters when they are the last characters in a file. This prevents the addition of an
unintended trailing record when the data mapping configuration is set up to cut on every
line.
Page 258