whats the best way to do this?

[Steve]

I have to create 2 strings and then parse one string out to save the data
into the database.

My first string looks like this:

Jo************* **@yahoo.com,Gr ***********@aol .com,Ke******** ****@gmail.com,

I then need to parse out that string to seperate them by the commas so I see
this
Jo************* **@yahoo.com
Gr***********@a ol.com
Ke************@ gmail.com
I then need to parse out that string so I get
John
Greg
Kelly

Smith
Henry
Smith

so I can save each value to the database, what is the best way to do this?
The stored procedure I'm calling is already parsing strings by the comma, so
would it be easier to just parse out the large string in code and pass the
smaller string with the pipe (|) and make a change to the proc to parse the
values by the (|) or should I do all of this in my C# code? If the C# way,
how would that be done? I'm able to get this string format
(Jo************ ***@yahoo.com) but when I try to parse it out, I' get errors
(Index was outside the bounds of the array)

[Alex Meleta]

Hi Steve,

SJ************* ***@yahoo.com,G r***********@ao l.com,Kelly|Smi th|ks@gmai

The <string>.Split( <separator>) method can be helpful.
http://msdn2.microsoft.com/en-us/lib...ing.split.aspx

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

[Steve]

I am currently doing that but when I split the first string by the comma(,)
its fine, its the second string Jo************* **@yahoo.com thats giving me
a fit.

when i do this:

String[] names= ViewState["custnames"].ToString().Spl it('|');
foreach (String n in names)
{
String[] u = n.ToString().Sp lit('|');
Response.Write( u[0]);
Response.Write( u[1]);
}

I'm getting this error:
Index was outside the bounds of the array, but if I do this
String[] names= ViewState["custnames"].ToString().Spl it('|');
foreach (String n in names)
{
String[] u = n.ToString().Sp lit('|');
Response.Write( u[0]);
}

I can see the first name in the string with no problem. So am I missing
something or doing something wrong in the sytnax?


"Alex Meleta" <am*****@gmail. comwrote in message
news:15******** *************** ***@msnews.micr osoft.com...

Hi Steve,

SJo************ ***@yahoo.com,G r***********@ao l.com,Kelly|Smi th|ks@gmai

The <string>.Split( <separator>) method can be helpful.
http://msdn2.microsoft.com/en-us/lib...ing.split.aspx

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

[Mark Rae [MVP]]

"Steve" <St***@communit y.nospam.comwro te in message
news:O7******** ******@TK2MSFTN GP02.phx.gbl...

so I can save each value to the database, what is the best way to do this?

strRaw =
"Jo************ ***@yahoo.com,G r***********@ao l.com,Ke******* *****@gmail.com ,";

foreach (string strRecord in strRaw.Split(', '))
{
string[] astrElements = strRecord.Split ('|');

strFirstName = astrElements[0];
strLastName = astrElements[1];
strEmailAddress = astrElements[2];
}
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Steve]

Mark,
I've tried that, I've tried everything I can think of and it only shows
[0] and anything beyond that give me the out of bounds error message.
"Mark Rae [MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:e8******** ******@TK2MSFTN GP04.phx.gbl...

"Steve" <St***@communit y.nospam.comwro te in message
news:O7******** ******@TK2MSFTN GP02.phx.gbl...

>so I can save each value to the database, what is the best way to do
this?

strRaw =
"Jo************ ***@yahoo.com,G r***********@ao l.com,Ke******* *****@gmail.com ,";

foreach (string strRecord in strRaw.Split(', '))
{
string[] astrElements = strRecord.Split ('|');

strFirstName = astrElements[0];
strLastName = astrElements[1];
strEmailAddress = astrElements[2];
}
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"Steve" <St***@communit y.nospam.comwro te in message
news:O5******** ******@TK2MSFTN GP05.phx.gbl...

I've tried that, I've tried everything I can think of and it only shows
[0] and anything beyond that give me the out of bounds error message.

Not sure what's happening, then - I've just tried it, and it works fine for
me.

Can you post your whole code...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Alex Meleta]

Hi Steve,

Probably the exception occurs in that piece of code:
SResponse.Write (u[1]);

You should check the boundaries.
Anyway, you can try to analyse that input string is correct, for doing this
change your code to something like code below:

foreach (String n in names)
{
foreach(String justForTest in n.ToString().Sp lit('|'))
{ Response.WriteL ine(justForTest ); }
Response.WriteL ine("-");
}

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

SI am currently doing that but when I split the first string by the
Scomma(,) its fine, its the second string Jo************* **@yahoo.com
Sthats giving me a fit.
S>
Swhen i do this:
S>
SString[] names= ViewState["custnames"].ToString().Spl it('|');
Sforeach (String n in names)
S{
SString[] u = n.ToString().Sp lit('|');
SResponse.Write (u[0]);
SResponse.Write (u[1]);
S}
SI'm getting this error:
SIndex was outside the bounds of the array, but if I do this
SString[] names= ViewState["custnames"].ToString().Spl it('|');
Sforeach (String n in names)
S{
SString[] u = n.ToString().Sp lit('|');
SResponse.Write (u[0]);
S}
SI can see the first name in the string with no problem. So am I
Smissing something or doing something wrong in the sytnax?
S>
S"Alex Meleta" <am*****@gmail. comwrote in message
Snews:15******* *************** ****@msnews.mic rosoft.com...
S>

>Hi Steve,

S>
Jo************ ***@yahoo.com,G r***********@ao l.com,Kelly|Smi th|ks@gmai

The <string>.Split( <separator>) method can be helpful.
http://msdn2.microsoft.com/en-us/lib...ing.split.aspx

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

[Steve]

sure:

code:
main string:
Jo************* **@yahoo.com,Gr ***********@aol .com,Ke******** ****@gmail.com,

String[] users= ViewState["Stuff"].ToString().Spl it(',');

which returns this:
Jo************* **@yahoo.com,

then I loop through that string;
foreach (string s in users)
{
string[] s= strRecord.Split ('|');

strFirstName = s[0];
strLastName = s[1];
strEmail = s[2];
}
Response.Write( strFirstName + " " + strLastName + " " +
strEmail);

and I get this error:
Index was outside the bounds of the array.
strLastName = astrElements[1];

"Mark Rae [MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:eb******** ******@TK2MSFTN GP03.phx.gbl...

"Steve" <St***@communit y.nospam.comwro te in message
news:O5******** ******@TK2MSFTN GP05.phx.gbl...

>I've tried that, I've tried everything I can think of and it only shows
[0] and anything beyond that give me the out of bounds error message.

Not sure what's happening, then - I've just tried it, and it works fine
for me.

Can you post your whole code...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Steve]

I've done that and I can see the string that is being passed

Jo************* **@yahoo.com,Gr ***********@aol .com,Ke******** ****@gmail.com,

I can see that just fine, hell i can even parse it out by the commas, its
splitting this string:
Jo************* **@yahoo.com

thats joking on me

"Alex Meleta" <am*****@gmail. comwrote in message
news:15******** *************** ***@msnews.micr osoft.com...

Hi Steve,

Probably the exception occurs in that piece of code:
SResponse.Write (u[1]);

You should check the boundaries.
Anyway, you can try to analyse that input string is correct, for doing
this change your code to something like code below:

foreach (String n in names)
{
foreach(String justForTest in n.ToString().Sp lit('|'))
{ Response.WriteL ine(justForTest ); }
Response.WriteL ine("-");
}

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

SI am currently doing that but when I split the first string by the
Scomma(,) its fine, its the second string Jo************* **@yahoo.com
Sthats giving me a fit.
SSwhen i do this:
SSString[] names= ViewState["custnames"].ToString().Spl it('|');
Sforeach (String n in names)
S{
SString[] u = n.ToString().Sp lit('|');
SResponse.Write (u[0]);
SResponse.Write (u[1]);
S}
SI'm getting this error:
SIndex was outside the bounds of the array, but if I do this
SString[] names= ViewState["custnames"].ToString().Spl it('|');
Sforeach (String n in names)
S{
SString[] u = n.ToString().Sp lit('|');
SResponse.Write (u[0]);
S}
SI can see the first name in the string with no problem. So am I
Smissing something or doing something wrong in the sytnax?
SS"Alex Meleta" <am*****@gmail. comwrote in message
Snews:15******* *************** ****@msnews.mic rosoft.com...
S>

>>Hi Steve,

S>
Jo*********** ****@yahoo.com, Gr***********@a ol.com,Kelly|Sm ith|ks@gmai

The <string>.Split( <separator>) method can be helpful.
http://msdn2.microsoft.com/en-us/lib...ing.split.aspx

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

[Mark Rae [MVP]]

"Steve" <St***@communit y.nospam.comwro te in message
news:ep******** ******@TK2MSFTN GP06.phx.gbl...

sure:

code:

<snip>

Hmm - can't see anything obviously wrong with that...

I'm clutching at straws now, but could you tell me what s.Length returns?
I'm wondering if there's some sort of CultureInfo conflict here which has
caused the Split method to fail to interpret the pipe symbol correctly... If
s.Length returns 1 instead of 3, I think that might be the reason...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net