String Manipulation (AGAIN!) 1

[Geee]

Ok this is what I want to do...
I've got a string which contains a list of comma delimited numbers like this "1,3,6,9,10,21". What I want to do is to take the numbers from the string and put them into an array of the same length. I presume that I will need to use InStr and Left and Right commands, but I cannot get my head around how to go about it.

Any help is great, I will buy the person who solves it a pint.

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[vasah20]

use split.

ex:
dim myarr
myarr=split(strToSplit,",&quot

if you don't specify the second param, it will look for spaces by default.

hth
leo

 

[Geee]

Precisely why this forum is so darn usefull! Thanks leo, worked a treat.

-GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-