title: Remove CSV formula values during mysql load data infile import
body: <p>So I'm trying import a .csv file directly into mysql using <code>load data local infile</code> command but I'm running into fields that are remnants an excel formula field and I don't know how to get rid of them.  The content for the first field in the example below has an <code>=</code> in front of it.</p>
  
  <p>The table structure is setup to allow the first field to be a <code>VARCHAR(100)</code> but I'd like to make it an <code>INT</code> if possible.  Here is a sample of the csv content that is being uploaded.  </p>
  
  <pre><code>"MID","DBA Name","Partner ID","Partner Name","Sub Partner ID","Sub Partner Name","Active Months","Bonus Amount","Bonus Applied Date","Partner Percentage","Partner Share","Total Payment"
  ="0008788014065741","company2","7968","me,"11839","Joe Blow","0","$50.00","","","","$350.64"
  ="0008788014065756","company2","7968","you","11839","Joe Blow","0","$50.00","","","","$294.60"
  </code></pre>
  
  <p>And here is the mysql load command that I'm using to import the data:</p>
  
  <pre><code>sql = """
      LOAD DATA LOCAL INFILE '%(upload)s' IGNORE INTO TABLE `%(table)s`
      FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' 
      LINES TERMINATED BY '\\r\\n' 
      IGNORE 1 LINES ;
        """ % {"upload": file, "table": report}
  self.db.query( sql )
  </code></pre>
  
  <p>Is there something that can be done on the import in terms of a regex or something? I don't know, I'm just grasping at straws here...</p>
  
  <p>Thanks for the input!</p>