Access/VBA Library

Split Method

Creates the array from a String containing a number of substrings which are separated by a specified delimiter.

Syntax

array_.Split( AnString [, Delimiter] )
Parameters
Name Type Description
array_   The name of an object of type array_
AnString String Required. Input string to retrieve the substrings from.
Delimiter String Optional. Separator of the substrings withing AnString.
Default: ";"
Example
  Dim x As New Array_

  x.Split ("Jeff;Morrison;USA")
  'Array (
  ' [1] = > Jeff
  ' [2] = > Morrison
  ' [3] = > USA
  ')