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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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