Split Function

c = "1,2,3,4,5,6"
a = Split(c, ",")


how do i know that my "a" array has 6 items in it

a.ubound

gives me an error

Should Declare Anything specially?

does that work? taking the split of an array? let me try that first then try to help.

what are you trying to do here? take a string and assign it to an array?

[Edited by billrogers on 07-31-2000 at 09:09 AM]

Ubound is a function in itself, not a method of an array.

Code:

---

Msgbox UBound(myArray)

---

yes, but what is it he is attempting to do here?

I believe he wants to take a string and try to assign it to an array, then get the ubound of that array.

Oops...

Let me delete this before anyone sees!


c = "1,2,3,4,5,6"
a = Split(c, ",")


for b = 0 to ubound(a)
debug.print a(b)
next b


Thanks
Alot

Bill.

This is my guess.

Code:

---

Dim c as String
Dim a() as String

c = "1,2,3,4,5"
a = Split(c,",")

---

OK you just delted that post, so mine now makes no sense. ;)

Don't worry Iain. That imaginary friend of yours will stop banging on the radiators during the night if you spend a few hours a week talking to somebody who can help you through this difficult, and no doubt stressful, time.

And while the shrink <ahem> psycho-emotional councillor deals with your problem(s), I would go easy on the hallucinogenic drugs. And the drink. And the smoking. And the gambling. And the women. Maybe not the women.

Together, you and your psycho-emotional councillor will be able to cure you from this vicious circle of drugs, lies, and programming.

You can save a life. Your own.

sorry iain, i figured it out. ;)

ROFL :D

"I'm fairly distressed here!", Dr. Iam Malcolm
Jurassic Park

I just thought it seemed appropriate here, "a.ubound" good heavens above! :)

10 years after the fact....

'zerobase + 1 gives the number of items
MsgBox UBound(a) + 1
'to print it's
Dim i
For i = LBound(a) to UBound(a)
debug.print a(i)
Next