Click button to edit
Advanced: 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