Reading CSV file with datetime column which can be invalid

Asked Jun 18 '19 at 15:22

Active Jun 18 '19 at 15:22

Viewed 99 times

I have a CSV file that I would like to read into a list in a C# code, for that matter I have used the CsvHelper package. The CSV file contains a DateTime column which can be invalid for some rows and would have the value: "00.00.0000" I am using the attribute : [DateTimeStyles(0)] which correctly converts the valid DateTime values, however I am having an exception when the value within the file is incorrect.

I would like to know if there is a way to ignore the rows with such values using attributes or if I would have to override the DateTimeStyles attribute itself.

Here is the class I am using to map the data:

class CsvRow
    {        
        public String field1{ get; set; }

        [DateTimeStyles(0)]
        public DateTime DateTimeFieldToConvert { get; set; }
}

asked Jun 18 '19 at 15:22

Claritta

1

Look into https://stackoverflow.com/a/46877578/7505395 – Patrick Artner Jun 18 '19 at 15:27
1

Thank you for directing me to the useful thread, I can ignore those rows by catching the exception thrown when trying to convert invalid columns. – Claritta Jun 18 '19 at 15:47

Reading CSV file with datetime column which can be invalid

0 Answers0