Change Comma-Separated Strings to Arrays

You can use the Visual Basic split function to convert a comma-separated string to an array. The function allows you to send a string as an IN parameter of a function instead of sending an array. Then the string can be converted into an array using this function.

Here’s an example of using the split function:

 Private Function GetArray() as Variant         Dim arrParams As Variant         arrParams = Split("Test1,Test2,Test3", ",")         GetArray=arrParams End Function
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: