title: Dealing with a csv file in a strange format
body: <p>I am using "LOAD DATA" functionality with phpmyadmin to update (or renew) some data in my database with the upload of an csv file. The csv file has 50 cols and 200k lines. This works pretty well and is very fast with this format:</p>
  
  <pre><code>100;101;102;103;104;....
  Alfred;Mueller;Exampplestreet 1;12121;Chicago;....
  John;Wiliams;Exampplestreet 2;12345;Dallas;....
  Mandy;Peterson;Exampplestreet 3;44554;LA;....
  ...
  </code></pre>
  
  <p>Now I ve the chance to fully automize this process by receiving a csv data file of a data provider. But the data provider delivered an csv file like this:</p>
  
  <pre><code>100#Alfred;101#Mueller;102#Exampplestreet 1;103#12121;104#Chicago;....
  100#John;101#Wiliams;102#Exampplestreet 2;103#12345;104#Dallas;....
  100#Mandy;101#Peterson;102#Exampplestreet 3;103#44554;104#LA;....
  </code></pre>
  
  <p>Is there any chance to handle the format of the provider? I never worked with a csv file formatted like this?</p>