title: Adding a Delimiter to a memo field in Access
body: <p>I am trying to delimit a memo field.  The field has within it multiple notes that I need to parse out into different columns.  Each note however follows the same logic, starts with mm/dd/yyyy then the note itself followed by a space.</p>
  
  <p>So an example for one memo field would be</p>
  
  <p>01/25/2000 worked on Rack-ID 03/03/2010 contracted Rack-ID 05/15/2014 updated Rack-ID</p>
  
  <p>I need each note parsed out into a different column in Access.</p>
  
  <p>I was working on the Split function in VBA, they had originally had "|" as a delimiter but removed it, now I have to pull on the dates</p>
  
  <p>Note "tbl_example" is the table in my test access database
  "Tx_example" is the name of the column holding the data to be delimited in my test access database</p>
  
  <pre><code>Sub Example()
  
  On Error GoTo err_Handler
  
  Dim rsD As DAO.Recordset
  Set rsD = CurrentDb.OpenRecordset("tbl_Example")
  
   Do While Not rsD.EOF
      rsD.Edit
      rsD!F1 = Trim(Split(rsD!Tx_Example, "|")(0))
      rsD!F2 = Trim(Split(rsD!Tx_Example, "|")(1))
      rsD!F3 = Trim(Split(rsD!Tx_Example, "|")(2))
      rsD.Update
      rsD.MoveNext
  Loop
  
  
  sub_Exit:
  
  rsD.Close
  Set rsD = Nothing
  Exit Sub
  
  err_Handler:
  
  If Err.Number = 9 Then
      Resume Next
  Else
      MsgBox "Err: " &amp; Err.Number &amp; vbNewLine &amp; Err.Description
  End If
  End Sub
  </code></pre>
  
  <p>Not certain how I replace the "|" with a date search.
  Also I'm not against doing a replace and inserting "|" right before each date so I would have my delimiter back.</p>
  
  <p>Problem is I'm not sure how to find the date in a text memo field, otherwise I would be able to use the replace function, or an update query.</p>
  
  <p>Any help is appreciated, thanks.</p>