Get the entire CSV line on error parsing or reading

Viewed 657

Get the entire Csv Line on parsing error

With CsvHelper we use :

MissingFieldFound:

Gets or sets the function that is called when a missing field is found.The default function will throw a CsvHelper.MissingFieldException.You can supply your own function to do other things like logging the issue instead of throwing an exception. Arguments: headerNames, index, context

BadDataFound:

Gets or sets the function that is called when bad field data is found. A field has bad data if it contains a quote and the field is not quoted (escaped). You can supply your own function to do other things like logging the issue instead of throwing an exception. Arguments: context

In the following MCVE, only MissingFieldFound capture the complete line when BadDataFound did not.

static void Main()
{
    using (var stream = new MemoryStream())
    using (var writer = new StreamWriter(stream))
    using (var reader = new StreamReader(stream))
    using (var csv = new CsvReader(reader))
    {
        writer.WriteLine("FirstName,LastName");
        writer.WriteLine("\"Jon\"hn\"\",\"Doe\"");
        writer.WriteLine("\"JaneDoe\"");
        writer.WriteLine("\"Jane\",\"Doe\"");
        writer.Flush();
        stream.Position = 0;

        var good = new List<Test>();
        var bad = new List<string>();
        var isRecordBad = false;

        csv.Configuration.BadDataFound = context =>
        {
            isRecordBad = true;
            bad.Add(context.RawRecord);
        };

        csv.Configuration.MissingFieldFound = (headerNames, index, context) =>
        {
            isRecordBad = true;
            bad.Add(context.RawRecord);
        };

        while (csv.Read())
        {
            var record = csv.GetRecord<Test>();
            if (!isRecordBad)
            {
                good.Add(record);
            }

            isRecordBad = false;
        }

        good.Dump();
        bad.Dump();
    }
}

public class Test
{
    public string FirstName { get; set; }
    public string LastName { get; set; }
}

I would like the result to be :

"Jon"hn"","Doe"
"JaneDoe"

Instead of :

"Jon"hn"", "JaneDoe"

For long Csv with a lot of column the rest of the line often have valuable information.

1 Answers

You can get the line with this:

 csv.Parser.Context.RawRecord;
Related