Get distinct value from comma seperated array using LINQ

Question

Supposed I have a string array like this

{
"A“，
”B",
"A,B,D",
"C"
}

Is it possible that I write a single LinQ to get the distinct values {"A","B","C","D"} into a List?

dahlbyk · Accepted Answer · 2011-07-27 02:38:50Z

6

lists.SelectMany(l => l.Split(',')).Distinct().ToList();

answered Jul 27, 2011 at 2:38

dahlbyk

78k8 gold badges105 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dlev · Accepted Answer · 2011-07-27 02:39:27Z

3

var distinctValues = myList.SelectMany(x => x.Split(',')).Distinct().ToList();

This will split each string, and then flatten them into a single list, and get the distinct elements.

If you want to get the elements in alpha order, then you can tack on a .OrderBy(x => x) right before .ToList().

answered Jul 27, 2011 at 2:39

dlev

48.7k5 gold badges127 silver badges133 bronze badges

Wegged · Accepted Answer · 2011-07-27 02:53:42Z

1

Fyi in linq query syntax its the same as the answers above

List s = new List() { "A","B","A,B,D","C"};

var result = (from x in s from y in x.Split(',') select y).Distinct().ToList();

answered Jul 27, 2011 at 2:53

Wegged

2,42321 silver badges26 bronze badges