如何使readfield读取下一个字段

Question

我的csv文件包含8列和300k行。以下是我的csv文件示例"0195153448"；"古典神话"；"Mark P.O.Morford"；"2002年"；"牛津大学出版社"；"http://images.amazon.com/images/P/0195153448.01.THUMBZZZ.jpg"；"http://images.amazon.com/images/P/0195153448.01.MZZZZZZZ.jpg"；"http://images.amazon.com/images/P/0195153448.01.LZZZZZZZ.jpg">
"0002005018"；"Clara Callan"；"Richard Bruce Wright"；"2001"；"HarperFlamingo Canada"；"http://images.amazon.com/images/P/0002005018.01.THUMBZZZ.jpg"；"http://images.amazon.com/images/P/0002005018.01.MZZZZZZZ.jpg"；"http://images.amazon.com/images/P/0002005018.01.LZZZZZZZ.jpg">

现在我有了这个阅读的代码

string path = @"C:UsersSEMRUKDesktopexcellerkitaplik.csv";
public DataTable GetDataTabletFromCSVFile(string PathFile)
{
DataTable csvData = new DataTable();
TextFieldParser csvReader = new TextFieldParser(PathFile);
csvReader.SetDelimiters(new string[] {";"});
csvReader.HasFieldsEnclosedInQuotes = true;
string[] colFields = csvReader.ReadFields();
foreach (string column in colFields)
{
DataColumn datecolumn = new DataColumn(column);
datecolumn.AllowDBNull = true;
csvData.Columns.Add(datecolumn);
}               
string[] fieldData = csvReader.ReadFields();
while (!csvReader.EndOfData)
{
for (int i = 0; i < fieldData.Length; i++)
{
if (fieldData[i] == "")
{
fieldData[i] = null;
}
MessageBox.Show(fieldData[i]);
}
csvData.Rows.Add(fieldData);
}
return csvData;
}

这样我可以阅读前8行。但在那之后我什么都看不懂了。它只读前面的8。我怎么能告诉代码它也应该读后面的标签。我尝试将\t添加到集合分隔符中，但没有成功。有什么建议吗？

Answer 1

static void Main(string[] args)
{

string path = "your_file_path";
string text = System.IO.File.ReadAllText(path);
string[] parsedText= text.Split(';');
foreach (var item in parsedText)
{
//do some
}
}