CSV Files Settings

Delimiters

• Field delimiter: Defines what character separates each fields in the file.
• Text Delimiter: Defines what character surrounds text fields in the file, preventing the Field Delimiter from being interpreted within those text delimiters.
• Comment Delimiter: Defines what character starts a comment line.
• 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 ).
• Lines to skip: Defines a number of lines lines in the CSV that will be skipped and not be used as Source Records.
• Set tabs as a field delimiter: Overwrites the Field delimiter option and sets the Tab character instead for tab-delimited files.
• Use header line: Uses the first line of the CSV a headers, which automatically names all extracted fields.
• Ignore unparseable lines: Ignores any line that does not correspond to the settings above.

Boundaries

• Record Limit: Defines how many Source Records are displayed in the Data Viewer. This does not affect output production, as generating output ignores this option. To disable the limit, use the value "0".
• Line Limit: Defines the limit of detail lines in any detail table. This is useful for CSV files with a high number of detail lines, which in the DataMapper interface can slow down things. This does not affect output production, as generating output ignores this option. To disable the limit, use the value "0".
• Split: Defines the type of rule that defines when a boundary is created, establishing a new record in the Data Sample (called a Source Record).
• • Record(s) per page: Defines a set number of lines in the CSV file that go in each Source Record
  • • Records: The number of records to show in each Source Records.
  • On Change: Defines a new Source Record when a specific field has a new value.
  • • Field Name: Displays the fields in the CSV line. The selected one's value determines new Boundaries.
  • On Script: Defines the boundaries using a custom user-defined JavaScript. For more information see JavaScript API.
  • On Field Value: Defines the boundary when the contents of a specific field value.
  • Field Name: Displays the fields in the CSV line. The selected one's value will be checked against the Expression below to create a new boundary.
  • Expression: Enter the value or Regular Expression that triggers a new boundary when it is the field value.
  • Use Regular Expression: Check so that the Expression box is treated as a regular expression instead of static text. For more information on using Regular Expressions (regex), see the Regular-Expressions.info Tutorial.

function myAddFunction(p1, p2) {
    return p1 + p2;
};              

var result = myAddFunction(25, 12); // returns 37!