C#将日期和时间格式拆分为Datatable

Question

我有一个带有服务器日志的CSV。我需要拆分日期/时间格式作为附加的图像到我的DataTable。

CSV txt文件示例

10.115.10.74-[20/mar/2016:03:38:14+0800]“Get/portal/images/banners/iot.jpg http/1.1”404 918“http://www.utem.edu.my/portal/”Mozilla/5.0（Windows NT 6.3；WOW64；RV:45.0)Gecko/20100101 Firefox/45.0“

到目前为止我所尝试的

string[] raw_text = System.IO.File.ReadAllLines("C:\\log4.csv");

string[] data_col = null;

int x = 0;
foreach (string text_line in raw_text)
{
    //MessageBox.Show(text_line);
    data_col = text_line.Split(' ', '<', '>', '[', ']', '-', '"', ';', '(', ')', '+', ':');


    if (x == 1)
    {
        for (int i = 0; i <= data_col.Count() - 1; i++)
        {
            my_datatable.Columns.Add(data_col[i]);
        }

        x++;
    }
    else
    {

        my_datatable.Rows.Add(data_col);
    }

Answer 1

检查下面的代码。我希望能有所帮助

        string[] raw_text = System.IO.File.ReadAllLines("C:\\log4.csv");
        string[] data_col = null;

        int x = 0;

        foreach (string text_line in raw_text)
        {
            //MessageBox.Show(text_line);
            data_col = text_line.Split(' ', '<', '>', '[', ']', '-', '"', ';', '(', ')', '+', ':');


            if (x == 1)
            {
                for (int i = 0; i <= data_col.Count() - 1; i++)
                {
                        my_datatable.Columns.Add(data_col[i]);
                        my_datatable.Columns.Add(Convert.ToDateTime(data_col[i]).ToString("ddMMMyyyy"));

                        my_datatable.Columns.Add(Convert.ToDateTime(data_col[i]).ToString("HH:mm tt"));

                         my_datatable.Columns.Add(Convert.ToDateTime(data_col[i]).ToString("zzz"));

                        my_datatable.Columns.Add(data_col[i]);
                }

                x++;
            }
            else
            {

                my_datatable.Rows.Add(data_col);
            }