C＃读取CSV文件的行值 [英] C# read CSV files row values

问题描述

如何从CSV文件中获取具有值P的X列的行列表

使用Linq





1，test1,112,124

2，test2,113,124

3，test3,132,121



如何读取具有4列值为124的行



我尝试过：

如何使用Linq $ b $从CSV文件
获取具有值'P'的X列的行列表b 
 
 1，test1,112,124 
 2，test2,113,124 
 3，test3,132,121 
 
如何读取有4列的行值为124 

解决方案

代码注释中的说明：

  var  csvList =  new  List< string> 
 {
   1，test1,112,124，
 < span class =code-string>  2，test2,113,124，
    3，test3,132,121 
}; 
 
  var  results = csvList 
  //  添加密钥 
。选择（x = >   new  {csv = x，key = x.Split（ new  [] {' ，'}）[ 3 ]}）
  //  按键过滤 
 .Where（x = >  x.key。等于（  124））
  / /  返回原始csv  
。选择（x = >  x.csv ）; 

How can i get the list of rows which are having X Column with value 'P' from a CSV File
using Linq


1,test1,112,124
2,test2,113,124
3,test3,132,121

How can i read rows which are having 4 column value as 124

What I have tried:

How can i get the list of rows which are having X Column with value 'P' from a CSV File
using Linq


1,test1,112,124
2,test2,113,124
3,test3,132,121

How can i read rows which are having 4 column value as 124

解决方案

Explanation in code comments:

var csvList = new List<string>
{
    "1,test1,112,124",
    "2,test2,113,124",
    "3,test3,132,121"
};

var results = csvList
    // Add a key
    .Select(x => new { csv = x, key = x.Split(new[] { ',' })[3] })
    // filter by key
    .Where(x => x.key.Equals("124"))
    // return original csv
    .Select(x => x.csv);

这篇关于C＃读取CSV文件的行值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！