Importing CSV files of Twitter Data

[Kimberly Chulis]

I'm able to import raw Twitter archives by converting .xls files into .csv, then using the following code:

load data local infile 'filename.csv' into table filename
fields terminated by ','
;

The issue is that one of my fields is unstructured Tweet text data and occasionally users Tweet using commas, and in these instances this above command reads the comma as a field break and the data is read incorrectly for that entry. My original file does not contain quotes or any additional characters to distinguish fields, and I have upwards of 200 separate .xls and associated .csv files. Is there code to add to the load data infile statement that will skip any commas in one of the specified fields? Is there a better way to read these files in using the Python extension, that will provide a more efficient workaround?