title: Change the date format in a csv .txt file before importing using mysqlbulkloader
body: <p>For anybody looking for an answer in the future, the best way to do this is using the load data local infile option, where you will need to call out your particular columns and designate the columns you want to preprocess with an @ symbol.  like the example below.  You may also need to update both your client and server side settings to allow the load data option to work.</p>
  <p>in my code example below i wanted to change the createdate field from the m/d/y format to the mysql format of yyyy-mm-dd</p>
  <pre><code>LOAD DATA local INFILE 'C:/Users/username/Documents/SAP/SAP GUI/QNs.txt'
                                              IGNORE
                                              INTO TABLE tbl_quality_notification
                                              FIELDS TERMINATED BY '|' 
                                              LINES starting by '|'
                                               TERMINATED BY '\r\n'
                                              IGNORE 6 ROWS
                                              
                                              (@CreateDate,
                                              NotificationNumber,
                                              ItemNumber,
                                              WorkOrder,
                                              MaterialNumber,
                                              MaterialDescription,
                                              Disposition,
                                              DeptResponsible,
                                              OperationCaused,
                                              DefQtyInt,
                                              DefQtyExt,
                                              TotalQty,
                                              WcOpFoundAt,
                                              OpDescription,
                                              DefectLocation,
                                              ProblemType,
                                              ProblemDescription,
                                              CauseCode,
                                              CauseDescription,
                                              RootCause,
                                              CorrectiveAction)
                                              SET CreateDate = STR_TO_DATE(@CreateDate, '%m/%d/%Y')
                                              
  </code></pre>