devxlogo

Change Comma-Separated Strings to Arrays

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

devx-admin

Share the Post: