c# - 如何比较 2 个逗号分隔的字符串值并在同一位置更新现有列表？

Question

我有一个包含一些值的字符串列表，我想比较列表中 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 作为输出。

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

Answer 1

这个“美”怎么样

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();