title: Python - How to split cell in a column to a new row based of a delmimeter
body: <p>Relatively new and trying to split some data with python from a CSV file. I am trying to parse this data and split it into a new row if a specific delimiter appears. Those delimiters are &nbsp;'.'&nbsp; ';'&nbsp; and '#'.  There are also no spaces in COL_C.  In addition, it wouldn't matter the order of the delimiters, if we find one of them, automatically create the new line.</p>
  
  <p>Here is the example data<br><br></p>
  
  <p><code>COL_A | COL_B |COL_C</code><br>
  <code>--------------------</code><br>
  <code>Hello | World | Hi.Can;You#Help</code></p>
  
  <p><br>
  the output i'm trying to get would be:
  <br></p>
  
  <p><code>COL_A | COL_B | COL_C</code><br>
  <code>----------------------</code><br>
  <code>Hello | World | Hi</code><br>
  <code>Hello | World | Can</code><br>
  <code>Hello | World | You</code><br>
  <code>Hello | World | Help</code><br>
  <br><br>
  example 2:</p>
  
  <p><code>COL_A | COL_B | COL_C</code><br>
  <code>----------------------</code><br>
  <code>Hello | World | Hi#123;move</code><br>
  <code>New   | line  | Can.I#parse;this.data</code> <br></p>
  
  <p><br><br></p>
  
  <p><br>
  the output i'm trying to get would be:
  <br><br></p>
  
  <p><code>COL_A | COL_B | COL_C</code><br>
  <code>----------------------</code><br>
  <code>Hello | World | Hi</code><br>
  <code>Hello | World | 123</code><br>
  <code>Hello | World | move</code><br>
  <code>New   | Line  | Can</code><br>
  <code>New   | Line  | I</code><br>
  <code>New   | Line  | parse</code><br>
  <code>New   | Line  | this</code><br>
  <code>New   | Line  | data</code><br></p>
  
  <p><br><br>
  If this data set had another row without Hello World and had world hello in the first two columns, i would like to display that with the corresponding third column's data parsed out into new rows.</p>
  
  <p>thanks!</p>