title: Read in Python with csv.reader a file with two different delimiter in the same file
body: <p>I want to import a file from MySQL to python but there are two type of delimiters in the same file, on the same line.</p>
  
  <p>For example:</p>
  
  <pre><code>FIELDA_FIELDB_FIELDC; FILEDD; FIELDE; FIELDF
  </code></pre>
  
  <p>I can split with <code>_</code> or <code>;</code> but cant find how to do both.</p>
  
  <p>I have tried</p>
  
  <pre><code>csv_data = csv.reader(csvfile, delimiter=';' and '_')
  csv_data = csv.reader(csvfile, delimiter=';' or'_')
  </code></pre>
  
  <p>I have also tried using csv.sniffer.</p>
  
  <p>But only one delimiter is used each time.</p>
  
  <p>How should i do ?</p>