Click button to edit
Missing Values: Handle Missing Values with Nullable
Using Nullable for missing values
If your files contain a field that can be empty
Input.txt
10248|VINET|04071996|32.38
10249|TOMSP||11.61
10250|HANAR|08071996|65.83
10251|VICTE||41.34
RecordClass.cs
[DelimitedRecord("|")]
public class Orders
{
public int OrderID;
public string CustomerID;
[FieldConverter(ConverterKind.Date, "ddMMyyyy")]
public DateTime? OrderDate;
public decimal? Freight;
}
Example.cs
var engine = new FileHelperEngine<Orders>();
var records = engine.ReadFile("Input.txt");
foreach (var record in records) {
Console.WriteLine(record.CustomerID);
Console.WriteLine(record.OrderDate);
Console.WriteLine(record.Freight);
}
Console
VINET
04/07/1996 12:00:00 a.m.
32,38
TOMSP
11,61
HANAR
08/07/1996 12:00:00 a.m.
65,83
VICTE
41,34