C# write to csv file

Question

I want to dynamically format any column's date to yyyy-MM-dd. I know i can conditionally set a specific column to this date format, but is there any way to do it dynamically for all columns that have dates. Currently I am using a try catch here which works for all dates, but the problem is that any columns that aren't dates i.e. a value of 3.8707 will become 01/03/8707 on the csv output

foreach (var array in from DataRow myrow in dt.Rows select row.ItemArray)
{
    for (i = 0; i < array.Length; i++)
    {
        try
        {
             DateTime date = DateTime.Parse(array[i].ToString());
             swOut.Write(date.Year + '-' + date.Month + '-' + date.Day + ",");
        }
        catch (Exception)
        {
             swOut.Write(array[i] + ",");
        }
     }
     swOut.WriteLine();                 
}

is the date format always the same dd/mm/yyy ? or does it differ between the entries in the array? — Mong Zhu
– Mong Zhu, Commented May 19, 2017 at 9:13

Community · Accepted Answer · 2017-05-23 12:34:37Z

1

Click here and copy the static class Extensions with the extension method toDate(...) I have written (don't forget to add using System.Globalization;). If you're using it, you can do it simply like this, without having to catch an exception:

var arrayItems = from DataRow myrow in dt.Rows select row.ItemArray;
foreach (var array in arrayItems)
{
    for (var i = 0; i < array.Length; i++)
    {           
        var strItem = (array[i] ?? "").ToString();
        var date=strItem.toDate("yyyy-MM-dd");
        if (!date.HasValue) {
            swOut.Write(strItem + ",");
        }
        else
        {
            swOut.Write(date.Value.Year + '-' + 
                            date.Value.Month + '-' + date.Value.Day + ",");
        }
    }
    swOut.WriteLine();
}

Note that if you have to match a different data format, just change the parameter in the funtion .toDate("yyyy-MM-dd"). You can even specify multiple data formats which are accepted, like so:

string[] dateFmt = {"M/d/yyyy h:mm:ss tt", "M/d/yyyy h:mm tt", 
                 "MM/dd/yyyy hh:mm:ss", "M/d/yyyy h:mm:ss", 
                 "M/d/yyyy hh:mm tt", "M/d/yyyy hh tt", 
                 "M/d/yyyy h:mm", "M/d/yyyy h:mm", 
                 "MM/dd/yyyy hh:mm", "M/dd/yyyy hh:mm"};

then inside the loop you can use it:

var date=strItem.toDate(dateFmt);

That way, they will be interpreted and parsed and then they will be converted into YYYY-MM-dd and written into the .csv file, as you have specified it in the Write statement of your for loop.

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered May 19, 2017 at 9:40

Matt

27.4k19 gold badges131 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

A.Dal Over a year ago

Thanks for that Matt. but toDate cannot be resolved. the static class your using

Matt Over a year ago

@A.Dal: Please read the beginning of my answer - click here and then copy it. This static class was written by me.

Matt Over a year ago

@A.Dal - with the hints I gave, could you fix it?

Matt Over a year ago

@A.Dal -You're welcome, glad to hear it is working! :-)

bhuvan salanke · Accepted Answer · 2017-05-19 09:18:32Z

Instead of making your own datetime format parser, you should use the one already available for you. DateTime.TryParseExact is your tool to convert a string in a date when you know the exact format. If you know in which format the date is present in the CSV, then Converting back the date, in the string format that you like, is another task easily solved by the override of ToString() specific for a datetime.

In your code, you are using try catch that will decrease the performance.

string[] values = lines1[i].Split(',');
if (values.Length >= 3)
{
    DateTime dt;
    if (DateTime.TryParseExact(values[0], "d-MMM-yyyy", 
        System.Globalization.CultureInfo.CurrentCulture, 
        System.Globalization.DateTimeStyles.None, out dt))
    {
        values[0] = dt.ToString("yyyy-MM-dd");
        lines1[i] = String.Join(",", values);
    }
}

Arion · Accepted Answer · 2017-05-19 09:13:49Z

0

You could check the type of the column. Like this:

if(array[i] is DateTime)
{
    var date=(DateTime)array[i];
    swOut.Write(date.Year + '-' + date.Month + '-' + date.Day + ",");
}
else
    swOut.Write(array[i] + ",");

answered May 19, 2017 at 9:13

Arion

31.3k10 gold badges74 silver badges89 bronze badges

Collectives™ on Stack Overflow

C# write to csv file

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related