How do i test to see if a comma is present ?

[afrika]

hello,
I am using this code below to count the number of variables after the comma

jumvar = 43352352,325324452,235234452,24523454
jumvarsplt = split(jumvar,",")
valnum = CInt(ubound(jumvarsplt))

But i would like to know how to test if the variable has a comma before running the above code.

how do i achieve this efficiently

rgds
Afrika

[RhythmAddict]

Easy...

dim x
searchIn = "XXX,XX"
searchFor = ","

If InStr(searchIn,searchFor) Then
'do whatever
end if

[afrika]

I dont receive replies to my post again, i wonder whats wrong

thanks Rhythm

[jimfraser]

Just so you know,
Running split on something that has no delimiters (commas in your case) will product an array with 1 element, so it will still work for most purposes.

aTest = Split("blah", ",")

For i = 1 to UBound(aTest)
response.write aTest(i)
Next

result ->> blah

[afrika]

So taht means that using aTEST(i) or aTest(0) woudl be the same ?

how can i get it to produce all the numbers, within the spilt

[cycbot]

vbscript arrays are "0" based. Meaning the first array element starts at index 0.

hence:
for i = 0 to ubound(YourArray)
'blah blah blah
next

Just so you know,
Running split on something that has no delimiters (commas in your case) will product an array with 1 element, so it will still work for most purposes.

aTest = Split("blah", ",")

For i = 1 to UBound(aTest)
response.write aTest(i)
Next

result ->> blah

[afrika]

guess u mean

aTest = Split("blah", ",")

For i = 0 to UBound(aTest)
response.write aTest(i)
Next

result ->> blah

works better that way, since we are starting form 0 in the array

thanks for you help

[jimfraser]

Oops, yep, my mistake

[afrika]

thanks anyway

Afrika