title: Split function on an array
body: <p>I have a large text file (1 long line) with multiple delimiters (eg: <code>~</code>, <code>*</code>, <code>:</code>). The <code>~</code> delimiter marks a new section, and the <code>*</code> and <code>:</code> delimiters mark sub sections or segments.</p>
  
  <p>I tried the following but I'm getting a type mismatch error, likely because the <code>Split</code> function is meant to be used on a string, not an array.</p>
  
  <pre><code>Dim  strFileLine, arrSection, arrSegment, arrSegField
  strFileLine = "C:\sometextfile.txt"
  arrSection  = Split(strFileLine, "~")
  arrSegment  = Split(arrSection, "*")
  arrSegField = Split(arrSegment, ":")
  </code></pre>
  
  <p>I'm trying to use this logic to keep my segments and segment fields with the correct section, and insert those value into a database.</p>
  
  <p>Any idea on how I can accomplish this with VBScript?</p>