Split on second occurrence

[soulpumpkin]

I have a string, path name, like this:
"c:\foo\Data Codes Mar 2004 - only codes.xls - 9/12/2004 10:23:12"

I need to parse this guy so that I have the following:
"c:\foo\Data Codes Mar 2004 - only codes.xls"

Any help would be great.

Soul Pumpkin

 

[jubble]

newstring=originalstring(0,originalstring.lastindexof("-"))

or something similar

 

[ca8msm]

There's quite a few ways of doing it. One would be:

        Dim s As String = "c:\foo\Data Codes Mar 2004 - only codes.xls - 9/12/2004 10:23:12"
        s = s.Substring(0, s.LastIndexOf("-") - 1)

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[jubble]

sorry...forget the substring bit

newstring=originalstring.substring(0,originalstring.lastindexof("-"))

 

[ca8msm]

Oops...sorry for the cross-post!

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[jubble]

lol

yours is much cleaner anyway

 

[jubble]

ha

I forgot the -1 too. I can never remember if it's -1 for the beginning substring or the end substring

 

[ThatRickGuy]

Why not just use the Split method?

NewString = OldString.Split("-")(2)

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[ThatRickGuy]

Whoops, you wanted the first two parts, not the third.

dim s() as string = OldString.Split("-")
NewString = s(0) & "-" & s(1)

But I would go for the already posted substring method for it instead.

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[soulpumpkin]

Thanks you guys rock, works great

Soul Pumpkin