title: Split a column of a data frame to multiple columns without duplicate
body: <p>I would like to split one column into two within at data frame based on a delimiter. For example,</p>
  
  <pre><code>METHAMPHETAMINE | MORPHINE
  THC
  </code></pre>
  
  <p>to became</p>
  
  <pre><code>METHAMPHETAMINE  MORPHINE
  THC
  </code></pre>
  
  <p>within a data frame.</p>
  
  <p>Thanks!</p>