How to convert a c# comma separated values string into a list?

Question

I'm using C# ASP.NET 4 and SQL Server 2008 R2

I'm getting an object scalar from sql server which is a string containing comma separated values of the form:

7, 12, ... 1, 65

I would like to convert this object into a list?

I thought of the direction:

List<int> myList = new List<int>(new int[] (List)mySqlClass.mySqlQueryReturningAnObject("SELECT CLAUSE");

but this is not going to work.

How do I convert this object into a list?

Full answer:

This answer in use is according to the selected answer (before the update)

List<int> myList = new List<int>(mySqlClass.mySqlQueryReturningAnObject("SELECT CLAUSE").ToString().Split(',').Select(x => Convert.ToInt32(x)).ToList());

possible duplicate of How to create a List<T> from a comma separated string? — dash
– dash, Commented Jun 18, 2012 at 13:21

Ribtoks · Accepted Answer · 2012-06-18 13:22:35Z

17

var intValues = line.Split(',').Select(x => Convert.ToInt32(x)).ToList();

Update

To ensure your code would be able to process strings like 1,2,3,,,4,5,6 you can use overload of String.Split method

var intValues = line.Split(new[] {','}, StringSplitOptions.RemoveEmptyEntries)
                    .Select(x => Convert.ToInt32(x))
                    .ToList();

edited Jun 18, 2012 at 13:22

answered Jun 18, 2012 at 13:14

Ribtoks

6,9711 gold badge29 silver badges43 bronze badges

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

Comments

dodexahedron · Accepted Answer · 2012-06-18 13:13:51Z

5

Use the .Split() method on the string. It will return an array of strings.

string yourResult = "1,2,3,4,5";
string[] resultsArray = yourResult.Split(new[] {','}, StringSplitOptions.RemoveEmptyEntries);

answered Jun 18, 2012 at 13:13

dodexahedron

4,6832 gold badges32 silver badges41 bronze badges

Comments

Panagiotis Kanavos · Accepted Answer · 2012-06-18 13:14:52Z

2

Did you try String.Split?

You can split your string with a line as simple as this:

var myString="1,2,4,5,6";
var numberList=myString.Split(',');

answered Jun 18, 2012 at 13:14

Panagiotis Kanavos

134k16 gold badges211 silver badges270 bronze badges

Comments

Tigran · Accepted Answer · 2012-06-18 13:17:21Z

2

You can use simple Array.ConvertAll instuction, like this:

string str = "1,2,3,4,5,7,8,9";
int[]resultInArray = Array.ConvertAll( str.Split(','), item => int.Parse(item));

answered Jun 18, 2012 at 13:17

Tigran

62.3k8 gold badges90 silver badges124 bronze badges

Comments

Marcello Faga · Accepted Answer · 2012-06-18 13:28:31Z

2

        private void TestParse()
        {
            string commaseparatedstring = "3, 5,6,19";

            int parsedvalue = 0;

            List<int> valuesint =
                commaseparatedstring.Split(',').Select(elem => int.TryParse(elem, out parsedvalue) ? parsedvalue : 0).ToList(); 

        }

answered Jun 18, 2012 at 13:28

Marcello Faga

1,2149 silver badges12 bronze badges

Comments

Gaz Winter · Accepted Answer · 2012-06-18 13:15:42Z

0

You could try assigning the result to a variable.

Then convert it into a string (if its not already one)

Then do a string split on the comma and assigning the results to a list.

answered Jun 18, 2012 at 13:15

Gaz Winter

2,9442 gold badges27 silver badges48 bronze badges

5 Comments

Different111222 Over a year ago

I should learn the basics first. I'm looking for something like List<int> myList= myCSVstring.Split(',').ToList(); but this ivokes: Cannot implicitly convert type 'System.Collections.Generic.List<string>' to 'System.Collections.Generic.List<int>' and I do not find where to convert the string into an int.

Gaz Winter Over a year ago

Do you need them as an int? If not then just make your list a list of strings. In fact you could still do that and then when you read them out of the list you can do a Convert.ToInt32(listitem)

Different111222 Over a year ago

Yes I need them as ints. Yes, I did that, I read the string and convert them to ints upon read. Is there a syntax for doing it upon assitnment?

Gaz Winter Over a year ago

This article might help with that bit stackoverflow.com/questions/44942/…

Gaz Winter Over a year ago

let us continue this discussion in chat

Collectives™ on Stack Overflow

How to convert a c# comma separated values string into a list?

Full answer:

6 Answers 6

Comments

Comments

Comments

Comments

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Full answer:

6 Answers 6

Comments

Comments

Comments

Comments

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related