string parse

Whats the most efficient way to parse a string like this..

1,2,3,4,5

I need to remove the commas and assign each number to an element in an array.


thanks,


knoxxx
JohnnyKnoxvilleAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
Indeed you should use split, however there is a limitation that Arthur has missed and mastallama has also missed (or copied from Arthur).

The array that you split to can only be declared as String or implicitly as variant which will get a subtype of String Array.

Dim arrMyArray() As Integer

Will generate a runtime error - 13 Type Mismatch

Dim arrMyArray() As String

Will not, likewise you could declare

Dim arrMyArray As Variant

0
 
Anthony PerkinsCommented:
arrMyArray = Split("1,2,3,4,5",",")

Anthony
0
 
Arthur_WoodCommented:
to be only slightly more complete:

Dim arrMyArray() as Integer
arrMyArray = Split("1,2,3,4,5",",")

0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
mastallamaCommented:
Dim arrMyArray() as Integer
Dim myNumbers as String
arrMyArray = Split(myNumbers,",")


this let's you split from a variable instead of hard coding the numbers into the Split function.
0
 
Arthur_WoodCommented:
TimCoffee, good catch.  What I posted was competely off the top of my head, as I did not have VB immediately available, so I could not test the code before I posted it.  Thanks.
0
 
JohnnyKnoxvilleAuthor Commented:
Excellent,

Thanks everyone for the help.


Knoxxx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.