2022.1

The maximum value for this option is 65,535 characters. The default value is 80
characters.
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/FF at end of file: Instructs the DataMapper to ignore any CR, LF, FF 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.
XML File Input Data settings
For an XML file you can either choose to use the root node, or select an element type, to create
a new delimiter every time that element is encountered.
l Use root element: Selects the top-level element. No other boundaries can be set. If there
is only one top-level element, there will only be one record.
l Use specific element: Displays a list containing all the elements in the XML file.
Selecting an element causes a new page of data to be created every time an instance of
Page 351