Common Flat File Issues

Find here a list of some common flat file issues, and how they can be implemented with the Designer:

• Flat File With Header Lines

  How to filter header rows of a flat file while processing it.

• Handling Empty Lines When Composing a Flat File

  How to handle empty data lines during flat file composition.

• Handling of White Spaces When Parsing Flat Files With Fixed Length

  How to handle white spaces when parsing a flat file with fixed length when the value "space" is a valid content and does not mean that this field is empty.

• Handling Quotes When Composing a Flat File

  How to automatically enclose strings in quotes when composing a flat file by using the quoteCharacter attribute.

• Mapping of Hierarchical Record Structures

  How to define a hierarchical record structure for flat files for the flat file record parser to parse the records into.

• Parsing Flat File Records Without Data

  How to parse a flat file that only contains empty records.

• Using Patterns to Separate Attributes

  How to use flat file patterns to split record fields during composing and parsing.

Related Content