how to use split function on strings

Question

0.00/5 (No votes)

See more:

Hi all,
When I try to read strings from excel sheet I am getting following format of strings in to an array[0].Through split(',') I am getting
"\"Title\" value. Can any one please advice me how to suppress "\" from it

[0] = "\"Title\",\"First Name\",\"Middle Name\",\"Last Name\",\"Suffix\",\"Company\",\"Department\",\"Job Title\",\"Business Street\",\"Business Street 2\",\"Business Street 3\",\"Business City\",\"Business State\",\"Business Postal Code\",\"Business Country/Regi...

Thanks

Posted 14-Oct-10 18:37pm

Jayadheer Reddy

Add a Solution

7 solutions

Solution 5

before you split the strings, remove the \" from it using the string.replace function as in:

C#

arrString[0] = arrString[0].Replace("\"",string.Empty);

Then, do your split.

Posted 15-Oct-10 7:10am

William Winner

Comments

Bikash Shrestha From Nepal 15-Oct-10 16:23pm

Do you agree with the statement of Abhinav s :- "Split can only split a string based on a single character." ???

William Winner 15-Oct-10 16:50pm

no...and I never said that I did...in fact, I believe I said that your answer was technically correct.

Solution 7

string aspdotnet, serverName, domainName, domainExtension;
aspdotnet = "www.aspdotnet.in";
string[] arr = aspdotnet.Split('.');
serverName = Convert.ToString(arr[0]);
domainName = Convert.ToString(arr[1]);
domainExtension = Convert.ToString (arr[2]);

OUT PUT :

serverName ="www"
domainName ="aspdotnet"
domainExtension ="in"

For more information this link may help you

For more information this link may help you

Click here.

Posted 30-Jun-11 2:51am

priyaroyals

Solution 1

Split can only split a string based on a single character.

You will need to remove the "\" from all strings in the split array, after the splitting has occured.

Posted 14-Oct-10 19:11pm

Abhinav S

Comments

William Winner 15-Oct-10 13:11pm

or instead of doing them one by one, you could remove it from the string before splitting it.

Solution 6

You should be reading the data keeping in mind it is in CSV format. Try putting a comma in one of the Excel cells then export that as CSV and see what you get. CSV is a common format... Google it and you should get some ideas for how to handle it. I know there is at least one library out there to read it for you.

But the simple answer you are probably looking for (also the wrong road to go down) is that you can use the Replace function to replace \" with " (or with nothing, if that is your preference).

Posted 15-Oct-10 7:11am

AspDotNetDev

Solution 8

Split string using c#

string aspdotnet, serverName, domainName, domainExtension;
aspdotnet = "www.aspdotnet.in";
string[] arr = aspdotnet.Split('.');
serverName = Convert.ToString(arr[0]);
domainName = Convert.ToString(arr[1]);
domainExtension = Convert.ToString (arr[2]);

OUT PUT :

serverName ="www"
domainName ="aspdotnet"
domainExtension ="in"

For more information this link may help you

For more information this link may help you

Click here.

Posted 30-Jun-11 2:57am

priyaroyals

Solution 2

string strData = "a,b,c,d,e,f,g,h,i,j";
char[] separator = new char[] { ',' };
string[] strSplitArr = strData.Split(separator);
foreach (string arrStr in strSplitArr)
{
Response.Write(arrStr + "" );
}

here it is to remove comma u can use as per ur requirement like.

Posted 14-Oct-10 19:15pm

Mohd Wasif

Comments

William Winner 15-Oct-10 13:12pm

he already know how to do the split. His problem was that the text was coming in with the double quotes surrounding the string types and he didn't want the double quotes around the text.

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)

Bikash Shrestha From Nepal · Accepted Answer · 2010-10-15T07:02:00

C#

string value = "shirt\r\ndress\r\npants\r\njacket";
        //
        // Use a new char[] array of two characters (\r and \n) to break
        // lines from into separate strings. Use "RemoveEmptyEntries"
        // to make sure no empty strings get put in the string[] array.
        //
        char[] delimiters = new char[] { '\r', '\n' };
        string[] parts = value.Split(delimiters, StringSplitOptions.RemoveEmptyEntries);

how to use split function on strings

7 solutions

Solution 5

Solution 7

Solution 4

Solution 1

Solution 6

Solution 8

Split string using c#

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us