C#从csv中提取数据

Question

我有一个这样的 CSV 文件:

field1,field2,field3,field4,...,fieldN
1,2,3,,...,N

我想准确提取第二行的第 14 条记录。我试过这段代码:

string nomeFile = "externalSourceMsg " + this.DataSource.CodSorgEst + this.DataSource.CodIdSorgEst + ".csv";
string content = "Field1,Field2,Field3,Field4,Field5,Field6,Field7" + Environment.NewLine;
content += externalMessage.ToString();
content = content.Replace(',', ';');

int i = 0;
while (content){
    int field;
    if(i++ == 13)
        field = content+i;
}

但它不起作用。我做错了什么？

Answer 1

拆分字符串，您可以通过索引访问字段。

 string nomeFile = "externalSourceMsg " + this.DataSource.CodSorgEst + this.DataSource.CodIdSorgEst + ".csv";
 string content = "Field1,Field2,Field3,Field4,Field5,Field6,Field7" + Environment.NewLine;
 content += externalMessage.ToString();
 content = content.Replace(',', ';');

 // Split the string by your separator -> you will get an array filled with fields
 string[] contentArr = content.Split(';');
 // Access any field you'd like by indexes 
 var The14thField = contentArr[13];