Automate

File Format Types

Use this page to Add Logical Paths.

To access this page, select IO Config > File Modification Types in the Navigation pane.

NOTE: It is not recommended to add new file modification types or to edit the delivered file modification types; the Automate code would need to be updated for the file modification type to properly work.

Field

Description

FILE FORMAT

Displays the names of the file formats. Options are:

  • Delimited — For each record in each file, fields are separated by a delimiter (configured by the Delimiter field on the Vertical View of the Logical Paths page). In a comma-separated values (CSV) file, the data items are separated using commas as a delimiter, while in a tab-separated values (TSV) file, the data items are separated using tabs as a delimiter. Column headers are sometimes included as the first line, and each subsequent line is a row of data.
  • Excel — Each file is an Excel file. When performing a straight copy of Excel files, the version does not matter. Excel libraries may need to be installed on the Stewardship Tier application server if Segment By Field or Batched (on the Vertical View of the Logical Paths page) are used when copying Excel files.
  • FixedWidth — Fixed width text files are special cases of text files where the format is specified by column widths, pad character and left/right alignment. Column widths are measured in units of characters. For example, if you have data in a text file where the first column always has exactly 10 characters, and the second column has exactly 5, the third has exactly 12 (and so on), this would be categorized as a fixed width text file.