读取CSV文件到DataTable

最新推荐文章于 2023-01-30 16:39:04 发布

原创最新推荐文章于 2023-01-30 16:39:04 发布 · 738 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#csv #string

C# 同时被 2 个专栏收录

47 篇文章

订阅专栏

Office

6 篇文章

订阅专栏

本文介绍了一种从CSV格式的一行数据中提取各列的具体方法，通过使用特定的字段和列分隔符，该方法能够准确地将数据按列进行划分。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

取CSV一行中的各列

public List<string> GetColumnsInRow(string row, char fieldDelimiter, char columnDelimiter)
        {
            List<string> result = new List<string>();
            string str = row;
            StringBuilder sb = new StringBuilder();
            bool startWithFieldDelimiter = false;
            bool jumpThis = false;
            bool matchOver = false;
            int length = str.Length;

            for (int i = 0; i < str.Length; i++)
            {
                if (i == 0)
                {
                    if (str[i].Equals(fieldDelimiter))
                    {
                        startWithFieldDelimiter = true;
                        matchOver = false;
                        jumpThis = true;
                    }
                    else if (str[i].Equals(columnDelimiter))
                    {
                        sb.Append("");
                        matchOver = true;
                        jumpThis = true;
                    }
                    else
                    {
                        matchOver = false;
                        jumpThis = false;
                    }
                }
                else
                {
                    #region fieldDelimiter
                    if (str[i].Equals(fieldDelimiter))
                    {
                        if (startWithFieldDelimiter)
                        {
                            if (i + 1 < length)
                            {
                                if (str[i + 1].Equals(columnDelimiter))
                                {
                                    matchOver = true;
                                    jumpThis = true;
                                    startWithFieldDelimiter = false;
                                }
                                else
                                {
                                    matchOver = false;
                                    jumpThis = false;
                                }
                            }
                            else
                            {
                                matchOver = true;
                                jumpThis = true;
                                startWithFieldDelimiter = false;
                            }
                        }
                        else
                        {
                            if (str[i - 1].Equals(columnDelimiter))
                            {
                                startWithFieldDelimiter = true;
                                jumpThis = true;
                                matchOver = false;
                            }
                            else
                            {
                                matchOver = false;
                                jumpThis = false;
                            }
                        }
                    }
                    #endregion
                    #region column delimiter
                    else if (str[i].Equals(columnDelimiter))
                    {
                        if (startWithFieldDelimiter)
                        {
                            matchOver = false;
                            jumpThis = false;
                        }
                        else
                        {
                            if (str[i - 1].Equals(columnDelimiter))
                            {
                                sb.Append("");
                            }
                            else if (sb.Length == 0)
                            {
                                continue;
                            }
                            matchOver = true;
                            jumpThis = true;
                        }
                    }
                    else
                    {
                        matchOver = false;
                        jumpThis = false;
                    }
                    #endregion
                }
                if (i == length - 1 && matchOver == false)
                {
                    if (!str[i].Equals(columnDelimiter) || (str[i].Equals(fieldDelimiter) && startWithFieldDelimiter == false))
                    {
                        sb.Append(str[i].ToString());
                        if (startWithFieldDelimiter)
                            sb.Insert(0, fieldDelimiter.ToString());
                    }
                    matchOver = true;
                }
                if (matchOver)
                {
                    result.Add(sb.ToString());
                    sb.Remove(0, sb.Length);
                    matchOver = false;
                    startWithFieldDelimiter = false;
                }
                if (jumpThis)
                    continue;
                else
                    sb.Append(str[i].ToString());
            }
            return result;
        }