Splitting an string into a string array.

Question

4.00/5 (1 vote)

See more:

I am facing a problem while executing a sql query in C#.The sql query throws an error when the string contains more than 1000 enteries in the IN CLAUSE .The string has more than 1000 substrings each seperated by ','.

I want to split the string into string array each containing 999 strings seperated by ','.

or

How can i find the nth occurence of ',' in a string.

Posted 9-Jan-13 20:17pm

bsb25

Updated 9-Jan-13 20:26pm

v3

Add a Solution

Comments

MT_ 10-Jan-13 2:21am

WHat have you done so far? In the question you are saying in "SQL" and tag says "C#", which one is true?

MT_ 10-Jan-13 4:58am

Thanks for updating the question. Please check the updated solution below.Milind

7 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andy411 · Answer 1 · 2013-01-09T20:22:00

Solution 2

Take a look at String.Split

C#

string foo = "a,b,c";

string [] foos = foo.Split(new char [] {','});

foreach(var item in foos)
{
   Console.WriteLine(item);
}

Posted 9-Jan-13 20:22pm

Andy411

Abhinav S · Answer 2 · 2013-01-09T20:20:00

Solution 1

You can do these very quickly in C#.
Just use the string.split function.

Something like this would work - strArry = myString.split(@",");

Posted 9-Jan-13 20:20pm

Abhinav S

MT_ · Answer 3 · 2013-01-09T20:24:00

In C#, simply use .Split

C#

string STR = "abc,def,ghi,jkl,mno,pqr";
string[] phrases = STR.Split(',');
string nthPhrase = phrases[n];

Alternatively, you can use RegEx to get the number as below

C#

String s = "abc,def,ghi,jkl,mno,pqr";
int n = 3;
int j=-1;
MatchCollection myMatches = Regex.Matches(s, ",");
if (myMatches.Count >= n-1 )
{
    j = myMatches[n - 1].Index;
}

Hope that helps, If it does mark it as answe/upvote.
Milind

Faisalabadians · Answer 4 · 2013-01-10T01:21:00

Solution 6

C#

string str = "this,is,a,sample,string";

            Func<string, string []> GetCount = x => x.Split(',');

            string [] num = GetCount(str);

would return you string array of length 5 like

C#

num[0]="this";
num[1]="is";
num[2]="a";
num[3]="sample";
num[4]="string";

Posted 10-Jan-13 1:21am

Faisalabadians

Comments

Matt T Heffron 10-Jan-13 13:38pm

Why the convolution of the Func... GetCount ?
Just use:
string [] num = str.Split(',');

sarathsprakash · Answer 5 · 2013-01-09T23:31:00

Solution 5

use Split function

C#

class Program
{
    static void Main()
    {
    string s = "Apple,Orange,Banana";
    string[] fruits = s.Split(',');
    foreach (string fruit in fruits)
    {
        Console.WriteLine(fruit);
    }
    }
}

Posted 9-Jan-13 23:31pm

sarathsprakash

puskar gupta · Answer 6 · 2013-01-09T20:28:00

C#

class Program
{
    static void Main()
    {
    string s = "there is a cat";
    //
    // Split string on spaces.
    // ... This will separate all the words.
    //
    string[] words = s.Split(' ');
    foreach (string word in words)
    {
        Console.WriteLine(word);
    }
    }
}

bsb25 · Answer 7 · 2013-01-14T23:50:00

Solution 7

MatchCollection mc = Regex.Matches(strList, c.ToString());
if (mc.Count >= numCount)
result = mc[numCount - 1].Index;

sIMILAR TO MILIND'S soLN

Posted 14-Jan-13 23:50pm

bsb25

Splitting an string into a string array.

7 solutions

Solution 2

Solution 1

Solution 3

Solution 6

Solution 5

Solution 4

Solution 7

Add your solution here

Preview 0

Splitting an string into a string array.

7 solutions

Solution 2

Solution 1

Solution 3

Solution 6

Solution 5

Solution 4

Solution 7

Add your solution here

Preview 0

Existing Members

...or Join us