• Read more about Automated Data Cleansing from Foundation Technology.

FileFormatType

Definition

            public enum FileFormatType
            {
                Unknown,
                Dbf,
                Csv,
                Delimited,
                Fixed,
                Excel,
                Access
            }
        

Description

Identifies the underlying file type of a FileFormat.

Data can be submitted in any of the following formats, or in these formats contained in a zip file with optional password protection.

• Unknown - indicates that the file type is not known; this is normally used in the FileFormat instance returned by the AutoDetectFormat method when a file that is not of one of the other available types is submitted.
• Dbf - the file is in DBase/FoxPro format.
• Csv - the file is in Comma Separated Values (CSV) format.
• Delimited - the file is in a delimited format; the specific delimiter is identified by the Delimiter field of the FileFormat instance.
• Fixed - the file is a fixed field width file; the offset and length of each column is defined by the Offset and Length fields of the FormatColumn instances.
• Excel - the file is an Excel 97 or later file; the worksheet within the spreadsheet that contains the data to cleanse is identified by the DataSet field of the FileFormat instance. Note that password protected Excel spreadsheets are not supported; data must be extracted from such files into a different format such as CSV or the password protection must be removed before submitting the file.
• Access - the file is an Access 97 or later file; the table within the database that contains the data to cleanse is identified by the DataSet field of the FileFormat instance.

When cleansed data is purchased, it is returned in the same format as it was submitted in with the exception of Excel and Access files, which are returned as CSV files.

File Format Store documentation