Context: |
Function |
Library/Class: |
Utilities |
Function ArrayToString() As String
ArrayToString (ItemArr As Variant, Separator As String) As String
This function converts an array of items into a text string, each array element separated by the separator string.
Parameters:
Array to be converted into a string. The array’s elements can consist of the
following data types: text, date time, integer, long, single or double. Arrays of
mixed data types are allowed.
Single character or a text string used as separator.
Return Value:
Sample:
|
Dim V_array As Variant
Dim S_Array(2) As String
Dim S_Text As String
S_Array(0) = “Car”
S_Array(1) = “Airplane”
S_Array(2) = “Train”
V_Array = S_Array
S_Text = ArrayToString(V_Array, “;”)
Call MessageDialog(S_Text,0,”ArrayToString Result”)
|
|
|