VB parser function

[mithrandir2001]

I have a string that has comma-delimited data (e.g. "cat, dog, mouse, bird"). Isn't there a native VB function that takes this kind of string as a parameter and outputs an array or collection with each substring as its own member (e.g. animals(0) = "cat", animals(1) = "dog", etc.)?

 

[Boogak]

You're looking for the split() function.

 

[Kewlb]

yup. Use the split() function split(string,delimiter)

 

[ggavinmoss]

And FYI, that is generally called tokenizing a string.

-geoff

 

[mithrandir2001]

Split()...yes, my memory is coming back. Thanks!