• Read more about Automated Data Cleansing from Foundation Technology.

FileFormat

Definition

            public class FileFormat
            {
                public FormatColumn[] Columns;
                public string Name;
                public string DataSet;
                public string Delimiter;
                public FileFormatType Type;
                public bool HeaderLine;
                public DataType DataType;
            }
        

Description

Describes a file format definition, including the underlying file type and the type of information stored in each column in the data.

• The Name field defines the unique name used to identify this file format.
• The Type field identifies the underlying file type, and can be one of the types listed in the FileFormatType enumeration.
• The Delimiter field indicates the character used to separate fields in the file when the Type field is set to Delimited. For other types of files, this field is unused.
• The DataSet field indicates which collection of data within the file is to be used. When the Type field is set to Access, this field indicates the name of the table in the Access database that the data should be taken from. When the Type field is set to Excel, this field indicates the name of the worksheet in the Excel spreadsheet that the data should be taken from.
• The HeaderLine field indicates whether or not the first row of data in the file is a header line.
• The DataType field indicates if the file contains business or residential records, or a mixture of both. This can be one of the types listed in the DataType enumeration.
• The Columns field contains an array of FormatColumn instances that define the type of information stored in each column. When the Type field is set to Fixed, the FormatColumn instances also define the length and offset of each column within the fixed format file.

File Format Store documentation