title: VBA - Txt file with two delimiters for rows and columns
body: <p>I have a <code>.txt</code> file where columns are delimited with <code>|</code> (pipe) but rows are delimited with the following string: <code>_ ~|~ _</code></p>
  
  <p>Is there a way to import this by delimiting rows based on the string? If I could just do that, I would be able to do text to columns easily. </p>
  
  <p>This is tricky because the space in each row in Notepad is being exhausted. For example:</p>
  
  <pre><code>Policy|Name|Cost _ ~|~ _ 11924|Joe|$20 _ ~|~ _ 154 (end of notepad space)
  
  35|Bob|$40 _ ~|~ _ 18439|Jane|$30 _ ~|~ _ 18492|Ri
  
  chard|$50
  </code></pre>
  
  <p>I need this to read:</p>
  
  <pre><code>Policy Name Cost
  
  11924  Joe  $20
  
  15435  Bob  $40
  
  18439  Jane $30
  
  18492 Richard $50
  </code></pre>
  
  <p>and so on. Note that values at the far right are split because notepad has exhausted its line length.</p>
  
  <p>Thanks for any ideas!</p>