String variable with comma delimited list to Array

[Jim]

Hello:

I have a variable which contains a comma delimited list contained in a
database variable e.g. "5,6,9,10,55,42" - I want to hand this list to
an array function to get it to populate an array, such as follows
(where rst!Q10ACode is the database variable):

Dim ListArray as Variant
Dim Substring1 as String

SubString1 = rst!Q10ACode
ListArray = Array(SubString1)

________________
When I do this, it returns the string length as 14, so I know it's
getting the string, but the UBound of the array is 0, and if I try to
access ListArray(1) and get an index out of bounds error. Can someone
let me know what I'm doing wrong?

Many thanks.

Jim

[Tom van Stiphout]

On Tue, 21 Aug 2007 14:02:13 -0000, Jim <ja*************@gmail.com>
wrote:

That's because of the difference between an array and a variant array.
The Array function returns the latter, the Split function the former.
Take your pick (but realize no variant arrays in DotNet).

-Tom.

>Hello:

I have a variable which contains a comma delimited list contained in a
database variable e.g. "5,6,9,10,55,42" - I want to hand this list to
an array function to get it to populate an array, such as follows
(where rst!Q10ACode is the database variable):

Dim ListArray as Variant
Dim Substring1 as String

SubString1 = rst!Q10ACode
ListArray = Array(SubString1)

________________
When I do this, it returns the string length as 14, so I know it's
getting the string, but the UBound of the array is 0, and if I try to
access ListArray(1) and get an index out of bounds error. Can someone
let me know what I'm doing wrong?

Many thanks.

Jim

[Tom van Stiphout]

On Tue, 21 Aug 2007 07:16:00 -0700, Tom van Stiphout
<no*************@cox.netwrote:

I should have added:
To iterate a variant array write:
dim v as variant
for each v in ListArray
...
next v

>On Tue, 21 Aug 2007 14:02:13 -0000, Jim <ja*************@gmail.com>
wrote:

That's because of the difference between an array and a variant array.
The Array function returns the latter, the Split function the former.
Take your pick (but realize no variant arrays in DotNet).

-Tom.

>>Hello:

I have a variable which contains a comma delimited list contained in a
database variable e.g. "5,6,9,10,55,42" - I want to hand this list to
an array function to get it to populate an array, such as follows
(where rst!Q10ACode is the database variable):

Dim ListArray as Variant
Dim Substring1 as String

SubString1 = rst!Q10ACode
ListArray = Array(SubString1)

________________
When I do this, it returns the string length as 14, so I know it's
getting the string, but the UBound of the array is 0, and if I try to
access ListArray(1) and get an index out of bounds error. Can someone
let me know what I'm doing wrong?

Many thanks.

Jim