首页> C#>如何比较两个逗号分隔的字符串值和更新现有列表在同一位置？

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了首页> C#>如何比较两个逗号分隔的字符串值和更新现有列表在同一位置？，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2849字，纯文字阅读大概需要5分钟。

内容图文

我有一个包含一些值的字符串列表,我想从列表中比较2个位置的值,并从列表中删除匹配项.

代码：

var list = new List<string>();
 list.Add("Employee1");
 list.Add("Account");
 list.Add("100.5600,A+   ,John");
 list.Add("1.00000,A+     ,John");
 list.Add("USA");

现在我想比较第二和第三位置：

list.Add("100.5600,A+   ,John");
list.Add("1.00000,A+     ,John");

比较上面的2条记录,并删除匹配的记录,如下所示：

预期产量：

list.Add("100.5600");
list.Add("1.00000");

这就是我想做的事情：

 var source = list[2].Split(',').Select(p => p.Trim());
 var target = list[3].Split(',').Select(p => p.Trim());
 var result = source.Except(target);

但是问题是我只能得到100.5600作为输出.

是否可以比较和更新现有列表中不匹配的记录？

解决方法:

这个“美女”怎么样

var list = new List<string>();
list.Add("Employee1");
list.Add("Account");
list.Add("100.5600,A+   ,John");
list.Add("1.00000,A+     ,John");
list.Add("USA");

//prepare the list, I decided to make a tuple with the original string in the list and the splitted array
var preparedItems = list.Select(x => (x, x.Split(',')));

//group the prepared list to get matching items for the 2nd and 3rd part of the split, I therefor used .Skip(1) on the previously prepared array
var groupedItems = preparedItems.GroupBy(x => string.Join(",", x.Item2.Skip(1).Select(y => y.Trim())));

//"evaluate" the group by saying if the items in the group is > 1 only use the first part of the prepared array and if it doesnt have more than one entry use the orignal string 
var evaluatedItems = groupedItems.SelectMany(x => x.Count() > 1 ? x.Select(y => y.Item2[0]) : x.Select(y => y.Item1));

//replace the orignal list with the new result
list = evaluatedItems.ToList();

编辑-保留原始顺序：

//extended the prepare routine with a third part the index to Keep track of the ordering of the original list
//so the tuple now consits of 3 parts instead of 2 - ([item], [index], [splittedArray])
var preparedItems = list.Select((x, i) => (x, i, x.Split(',')));

//changed to use Item3 intead of Item2 - since the Array now is on third position
var groupedItems = preparedItems.GroupBy(x => string.Join(",", x.Item3.Skip(1).Select(y => y.Trim())));

//instead of returning the simple string here already, return a tuple with the index (y.Item2) and the correct string
var evaluatedItems = groupedItems.SelectMany(x => x.Count() > 1 ? x.Select(y => (y.Item2, y.Item3[0])) : x.Select(y => (y.Item2, y.Item1)));

//now order by the new tuple x.Item1 and only return x.Item2
var orderedItems = evaluatedItems.OrderBy(x => x.Item1).Select(x => x.Item2);

list = orderedItems.ToList();


//one-liner - isn't that a beauty
list = list.Select((x, i) => (x, i, x.Split(','))).GroupBy(x => string.Join(",", x.Item3.Skip(1).Select(y => y.Trim()))).SelectMany(x => x.Count() > 1 ? x.Select(y => (y.Item2, y.Item3[0])) : x.Select(y => (y.Item2, y.Item1))).OrderBy(x => x.Item1).Select(x => x.Item2).ToList();

内容总结

以上是互联网集市为您收集整理的首页> C#>如何比较两个逗号分隔的字符串值和更新现有列表在同一位置？全部内容，希望文章能够帮你解决首页> C#>如何比较两个逗号分隔的字符串值和更新现有列表在同一位置？所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端