Join list of string to comma separated and enclosed in single quotes

Question

List<string> test = new List<string>();
test.Add("test's");
test.Add("test");
test.Add("test's more");
string s = string.Format("'{0}'", string.Join("','", test));

now the s is 'test's','test','test's more' but I need to replace the inner quotes with 2 single quotes

like this: 'test''s','test','test''s more'

update: I got it to work as below, but I would prefer a cleaner way if possible.

string s = string.Format("`{0}`", string.Join("`,`", test)).Replace("'", "''").Replace("`", "'");

Jay Riggs · Accepted Answer · 2018-05-29T17:49:54.970

77

This should work:

List<string> test = new List<string>(); 
test.Add("test's"); 
test.Add("test"); 
test.Add("test's more");
string s = string.Join("','", test.Select(i => i.Replace("'", "''")));

And if you're really looking to enclose the whole thing in single quotes:

string s = string.Format("'{0}'", string.Join("','", test.Select(i => i.Replace("'", "''"))));

edited May 29 '18 at 17:49

answered Aug 03 '11 at 23:59

Jay Riggs

53,046
9
139
151

score 34 · Answer 2 · edited Sep 18 '12 at 14:01

34

This may be easier than using string.replace

string s = "'" + String.Join("','", test) + "'";

edited Sep 18 '12 at 14:01

Scott

21,211
8
65
72

answered Sep 18 '12 at 12:00

CraigH

349
3
2

2

But this doesn't escape the single quotes. Solution by Jay Riggs is correct for the original poster's situation. – iheartcsharp Nov 27 '13 at 16:20

score 3 · Answer 3 · answered Aug 03 '11 at 23:58

3

Try this:

string s = string.Join(",", test.Select(x => string.Format("'{0}'", x.Replace("'", "''"))));

By the way, there's no apostrophe in "tests" - apostrophes aren't used for plurals.

answered Aug 03 '11 at 23:58

Simon MᶜKenzie

8,344
13
50
77

:) You are right. I made up some test list, I didn't really mean to say test's. Just some data with apostrophe is all I wanted. – coder Aug 04 '11 at 00:15

score 3 · Answer 4 · answered Aug 03 '11 at 23:58

3

It isn't to everyone's taste, but I like to create helper extensions for these kinds of tasks, and put them into a "utility" namespace:

public static class ListExtensions
{
   public static void AddDoubleQuoted(this List<string> list, string input)
   {
     input = input.Replace("'", "''");
     list.Add(input);
   }
}

List<string> test = new List<string>();
test.AddDoubleQuoted("test's");
test.AddDoubleQuoted("test");
test.AddDoubleQuoted("test's more");
string s = string.Format("'{0}'", string.Join("','", test));

answered Aug 03 '11 at 23:58

davecoulter

1,806
13
15

this one is cool, I prefer the above one is because I need it in just one place to use it. However I just learned how to create extensions. Thanks. – coder Aug 04 '11 at 00:11
@gangt No problem! The first time I learned extensions I thought it was pretty awesome too. – davecoulter Aug 04 '11 at 00:12

score 3 · Answer 5 · edited Apr 24 '23 at 16:48

3

string s = string.Join(
    ',', itemsList.Select(
        i => $"'{i}'"));

Using string interpolation. String.Replace is not required here.

edited Apr 24 '23 at 16:48

tripleee

175,061
34
275
318

answered Apr 05 '22 at 22:12

Som Das

31
1

score 0 · Answer 6 · answered Aug 03 '11 at 23:55

0

You can always encode quotes before you build your string.

answered Aug 03 '11 at 23:55

ika

1,889
2
12
9

2

It should be a comment not an answer! – Mehdi Dehghani Dec 20 '18 at 11:16

Nissanna · Answer 7 · 2023-04-24T15:57:38.673

0

string.Join(",", listofstring.Select(x=> $"'{x}'"))

edited Apr 24 '23 at 15:57

answered Apr 24 '23 at 15:56

Nissanna

1
3

score -1 · Answer 8 · answered Jul 08 '15 at 15:41

-1

I like a version without Replace:

using System.Linq;
(...)
string s = String.Join(", ", from l in MyList select String.Format("'{0}'", l));

answered Jul 08 '15 at 15:41

Starli0n

123
2
10

Join list of string to comma separated and enclosed in single quotes

8 Answers8

Linked