Sorry I miss spoke. So the fields are space delimited and the lines are linefeed delimited. I have made progress on this. The issue I have now is one field is ecapsulated by "" and inside the quotes there is a space. Which SQL is interpreting as another field. Below is the data requested. My apologies for not supplying it earlier.
Picture of the table in MySQL workbench
Lines of Sample data
128.1.1.20 - - [03/Feb/2015:00:00:00 -0600] "GET /isweb/servlet/PrintFilePollingServlet?id=248504470001111CC536F.ipf&version=2.01.01&pc=001111CC536F HTTP/1.1" 200 45 "-" "Java/1.7.0_40"
128.1.1.243 - - [03/Feb/2015:00:00:00 -0600] "GET /isweb/servlet/PrintFilePollingServlet?id=6967057597C0507ACC6EA.ipf&version=2.01.01&pc=7C0507ACC6EA HTTP/1.1" 200 45 "-" "Java/1.7.0_40"
Query I am currently using
load data infile '/tmp/sql/iweb.txt'
into table StandardGolfIweb
fields terminated by ' ' optionally enclosed by ""
lines terminated by '\r\n';
Results of query