title: Split date and time in a string using substring
body: <p>what is the best way to split the date and time.(See below example)
  How can I do it so that column 1 with original string will be splitted into 2 columns the date and time. My problem is the string may contain a single digit in Date or Time (eg. 11/9/2018) the 9 is single digit, If I will use substring array the total count will not be the same if the date is 11/10/2018.</p>
  
  <p>eg.</p>
  
  <pre><code>Column 1 (Date1) (original string)
  
  11/9/201812:52:53 AM
  
  Column 2 (Date2)
  
  11/9/2018
  
  Column 3 (Time1)
  
  12:52:53 AM
  </code></pre>
  
  <p>My codes so far, I can split the date but this will only will work if I have a fixed number of character in a string.</p>
  
  <pre><code>For i As Integer = 0 To DataGridView6.Rows.Count - 1 Step +1
  
  Dim split(1) As String
  
  split(0) = DataGridView2.Rows(i).Cells(0).Value.substring(0, 8)
  
  split(1) = DataGridView2.Rows(i).Cells(0).Value.substring(8, 6)
  
  DataGridView2.Rows(i).Cells(15).Value = split(0)
  
  DataGridView2.Rows(i).Cells(16).Value = split(1)
  
  Next
  </code></pre>