Defining character-separated fields

Fields in a character-separated flat file, for example in CSV, are defined in the flat file definition by dragging and dropping it in a similar way as with position-based flat files. With character-separated files, however, you can drag and drop multiple fields from a record. Use this procedure to define character-separated files in a flat file definition using the Template Flat View.

  1. Open an existing character-separated flat file.
  2. In the Template Flat view, select a field or multiple fields to define and drag it to the Message Definition view.
  3. If this is the first field to be defined, drop the field on the record. Otherwise, drop the field on the previous field.

    The field or field components are created in the Message Definition view.

  4. After the structure is defined, set the metadata of the field such as Name and TagName and other mandatory properties in the Properties view.

    For more information on setting properties and metadata, see Changing the message component property values.