how do I split a value in varchar

Question

0.00/5 (No votes)

See more:

VS2010

Hello, I want to split a value taken from a textbox and save it in two different variables. I have a phone number of 10 digit eneterd in a textbox and I want to save first 3 digit into a variable called "code" and next 7 digit into a variable called number. Please specify a concept to do this. By using which methodology can I achieve this??

Posted 30-Sep-15 3:26am

Member 11949886

Add a Solution

2 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)

OriginalGriff · Accepted Answer · 2015-09-30T03:33:00

Solution 1

If it's always 10 characters then just use string.Substring:

C#

string code = tbNumber.Text.Substring(0, 3);
string number = tbNumber.Text.SubString(3);

Posted 30-Sep-15 3:33am

OriginalGriff

Comments

Member 11949886 30-Sep-15 9:36am

yeah its always ten character.. but does it works??

Member 11949886 30-Sep-15 9:37am

string number = tbNumber.text.substring(3) is it correct or tbNumber.text.substring(4,9) is it correct.

phil.o 30-Sep-15 9:40am

First one. You have to assign the result of Substring method to a variable, because the original string will not be modified.

OriginalGriff 30-Sep-15 9:48am

Try it - or look at the MSDN documentation.
Substring has two overloads:
https://msdn.microsoft.com/en-us/library/system.string.substring%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396

CB Sharma · Accepted Answer · 2015-09-30T03:37:00

Solution 2

Hello

Please use below code

C#

string sPhoneNumber = "1234567890";
           string sCode = "";
           string sNumber = "";
           if (sPhoneNumber.Length==10)
           {
               sCode = sPhoneNumber.Substring(0, 3);
               sNumber = sPhoneNumber.Substring(3);
           }

Code have the first three digit and number have the last 7 digit.

Posted 30-Sep-15 3:37am

CB Sharma

Comments

Member 11949886 30-Sep-15 9:39am

are u sure?? sNumber = sPhoneNumber.Substring(3) is correct??

CB Sharma 30-Sep-15 9:41am

Yes, Implement my code and debug.