Smart Format Detector

Detect the format from a flat file

input.txt

Id|Company Name|Representative|Position|Address|City|Country
ALFKI|Alfreds Futterkiste|Maria Anders|Sales Representative|Obere Str. 57|Berlin|Germany
ANATR|Emparedados y Helados|Ana Trujillo|Owner|Avda. Constitución 2222|México D.F.|Mexico
ANTON|Antonio Moreno Taquería|Antonio Moreno|Owner|Mataderos  2312|México D.F.|Mexico
BERGS|Berglunds snabbköp|Christina Berglund|Administrator|Berguvsvägen  8|Luleå|Sweden
BLAUS|Blauer Delikatessen|Hanna Moos|Sales Rep|Forsterstr. 57|Mannheim|Germany
BOLID|Bólido Comidas preparadas|Martín Sommer|Owner|C/ Araquil, 67|Madrid|Spain

Example.cs

var detector = new FileHelpers.Detection.SmartFormatDetector();
var formats = detector.DetectFileFormat("input.txt");

foreach (var format in formats)
{
    Console.WriteLine("Format Detected, confidence:" + format.Confidence + "%");
    var delimited = format.ClassBuilderAsDelimited;

    Console.WriteLine("    Delimiter:" + delimited.Delimiter);
    Console.WriteLine("    Fields:");

    foreach (var field in delimited.Fields)
    {
       Console.WriteLine("        " + field.FieldName + ": " + field.FieldType);    
    }
    
    
}

Console

Format Detected, confidence:100%
    Delimiter:|
    Fields:
        Id: System.String
        Company_Name: System.String
        Representative: System.String
        Position: System.String
        Address: System.String
        City: System.String
        Country: System.String