• Read more about Automated Data Cleansing from Foundation Technology.

FormatColumn

Definition

            public class FormatColumn
            {
                public string Name;
                public KnownColumnTypes ColumnType;
                public int Offset;
                public int Length;
                public string Description;
                public string Header;
            }
        

Description

Defines the details of a column within a FileFormat definition.

• The Name field defines a unique name for each column within the file format.
• The ColumnType field defines the type of data that is stored in the column - this can be any one of the values listed in the KnownColumnTypes enumeration.
• The Offset field defines the position of the data in the column from the start of the line, in characters, for fixed format files. If the Type field of the FileFormat instance is not set to Fixed, this field can be ignored.
• The Length field defines the amount of data in the column, in characters, for fixed format files. If the Type field of the FileFormat instance is not set to Fixed, this field can be ignored.
• The Description field allows the calling program to supply a human-readable description of the field for its own use.
• The Header field defines the text to use for the column header when an output file is generated. This is only used when the HeaderLine field of the FileFormat instance is set to true.

File Format Store documentation