How create a string of distinct values from an Array (Including additional chars)

Question

I have a simple question for the LINQ experts. I want create a single string based in an Array:

return String.Join(",", (from string val 
     in arrayValues
     select new { value = "%" + val.ToString() + "%" })
     .Distinct().ToArray());

This code give an error, but I cannot found the way how fix the issue.

Example; I want to send {"1","2","3","4"} and my expected result should be something like that: "%1%,%2%,%3%,%4%"

Any help will be welcome!

Lee · Accepted Answer · 2014-06-17 22:06:37Z

2

It's not clear from your example why you need Distinct but you can do:

return string.Join(",", arrayValues.Distinct().Select(s => "%" + s + "%"));

or

var values = from val in arrayValues.Distinct() select "%" + val + "%";
return string.Join(",", values);

answered Jun 17, 2014 at 22:06

Lee

145k20 gold badges243 silver badges292 bronze badges

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

1 Comment

I still feel very familiar with the VB.NET. I not saw this workaround in C#.

Reed Copsey · Accepted Answer · 2014-06-17 22:06:18Z

2

You can just use:

return String.Join(",", arrayValues.Distinct().Select(v => "%" + v + "%"));

If you always will have at least one element, you could also use:

return "%" + string.Join("%,%", arrayValues.Distinct()) + "%";

answered Jun 17, 2014 at 22:06

Reed Copsey

567k80 gold badges1.2k silver badges1.4k bronze badges