Convert Array of Strings to Comma Separated String with additional concatenation

c# string linq concatenation comma
Reddy picture Reddy · Nov 2, 2015 · Viewed 22.2k times · Source

Is there any way to convert a list of strings to a comma-separated string?

String[] data = new String[] { "test", "abc", "123" }

Convert into: 

'test', 'abc', '123'

Possible solutions:

  1. Surround every string with '' and then use String.join on the list.
  2. Foreach each string in the list and do the concatenation of '' and ',' and in the end remove last ','

Is there any simple Linq (one line expression) to do both?

Answer

Merlyn Morgan-Graham picture Merlyn Morgan-Graham · Nov 2, 2015

Is there any simple Linq (one line expression) to do both.

string.Join(",", data.Select(item => "'" + item + "'"))

Basics of Linq: Transforms are Select statements. Filters are Where statements.

That said, there are a lot of string manipulation tools available that aren't Linq, and they're more likely to be optimized for strings, so I'd always look to them before looking to Linq.

Related questions

How do I use LINQ Contains(string[]) instead of Contains(string)

I got one big question. I got a linq query to put it simply looks like this: from xx in table where xx.uid.ToString().Contains(string[]) select xx The values of the string[] array would be numbers like (1,45,20,10,etc...) …

Read More
Comparing two string arrays in C#

Say we have 5 string arrays as such: string[] a = {"The","Big", "Ant"}; string[] b = {"Big","Ant","Ran"}; string[] c = {"The","Big","Ant"}; string[] d = {"No","Ants","Here"}; string[] e = {"The", "Big", "Ant", "Ran", "Too", "Far"}; Is there a method to …

Read More
How to convert IEnumerable<string> to one comma separated string?

Say that for debugging purposes, I want to quickly get the contents of an IEnumerable into one-line string with each string item comma-separated. I can do it in a helper method with a foreach loop, but that's neither fun nor …

Read More