Split Function

[kurtsimons]

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?

[billrogers]

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]

[Iain17]

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

Msgbox UBound(myArray)

[billrogers]

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.

[kurtsimons]

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

[Iain17]

Bill.

This is my guess.

Dim c as String
Dim a() as String

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

[Iain17]

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

[V(ery) Basic]

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.

[billrogers]

sorry iain, i figured it out.

[HarryW]

ROFL

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

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

[HeSaidJoe]

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