Need Help With VBscript

[AutoShutdown]

I am using VBscript in a asp file.
lets say I have a value...

abc="JDD-20015-19,12"
def="JDD-20015-07,8"
Question (1)
How can I strip everything except
the one after the comma(,) ?
I mean, after I strip 'abc',all that is left is '12' and
after I strip 'def',all that is left is '8'.

Question (2)
How can I strip everything except
the two number before the comma(,) ?
I mean, after I strip 'abc',all that is left is '19' and
after I strip 'def',all that is left is '07'.

I'm an ultimate beginner in VBscript.
Help is really appreciated.
Thanks Very Much...:)

--
AutoShutdown
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

[McKirahan]

"AutoShutdown" <Au*****************@mail.codecomments.com> wrote in message
news:Au*****************@mail.codecomments.com...

I am using VBscript in a asp file.
lets say I have a value...

abc="JDD-20015-19,12"
def="JDD-20015-07,8"
Question (1)
How can I strip everything except
the one after the comma(,) ?
I mean, after I strip 'abc',all that is left is '12' and
after I strip 'def',all that is left is '8'.

new abc = Mid(abc,InStrRev(abc,",")+1)

Question (2)
How can I strip everything except
the two number before the comma(,) ?
I mean, after I strip 'abc',all that is left is '19' and
after I strip 'def',all that is left is '07'.

newabc = Mid(abc,InStrRev(abc,"-")+1)
newabc = Left(abc,InStr(abc,",")-1)

I'm an ultimate beginner in VBscript.
Help is really appreciated.
Thanks Very Much...:)

Get a hold of the VBScript documentation at:
http://msdn.microsoft.com/scripting

<URL:
http://msdn.microsoft.com/library/de...us/script56/ht
ml/0a8270d7-7d8f-4368-b2a7-065acb52fc54.asp>

[Jeff Cochran]

On Thu, 5 Jan 2006 04:28:33 -0600, AutoShutdown
<Au*****************@mail.codecomments.com> wrote:

I am using VBscript in a asp file.
lets say I have a value...

abc="JDD-20015-19,12"
def="JDD-20015-07,8"
Question (1)
How can I strip everything except
the one after the comma(,) ?
I mean, after I strip 'abc',all that is left is '12' and
after I strip 'def',all that is left is '8'.
Best method would be RegExp, though a split might get what you're
looking for.
Question (2)
How can I strip everything except
the two number before the comma(,) ?
I mean, after I strip 'abc',all that is left is '19' and
after I strip 'def',all that is left is '07'.

Same thing.

See:

http://www.4guysfromrolla.com/webtech/090199-1.shtml

Jeff

[Bob Barrows [MVP]]

AutoShutdown wrote:

I am using VBscript in a asp file.
lets say I have a value...

abc="JDD-20015-19,12"
def="JDD-20015-07,8"
Question (1)
How can I strip everything except
the one after the comma(,) ?
I mean, after I strip 'abc',all that is left is '12' and
after I strip 'def',all that is left is '8'.
Use the Split() function to split the string on the comma, putting the
results into an array:
ar=split(abc,",")

The last element in the array will contain the substring you want.
newstring=ar(ubound(ar))


Question (2)
How can I strip everything except
the two number before the comma(,) ?
I mean, after I strip 'abc',all that is left is '19' and
after I strip 'def',all that is left is '07'.
Split the penultimate element in the array created by the first split using
the hyphens to do the split:

ar2=split(ar(ubound(ar)-1),"-")

Again, the last element in the new array will contain the string you want:
secondstring=ar2(ubound(ar2))

I'm an ultimate beginner in VBscript.
Help is really appreciated.
Thanks Very Much...:)

You can download the vbscript documentation here:
http://tinyurl.com/7rk6

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"