Load data - fields terminated by character appearing within a field statement
To answer your question yes I'm sure it is possible to employ a scheme like jkavalik suggested where you:


Import the entire file into a single column/cell in a temp table
Parse the malformed csv string using increasingly obtuse trickery as each edge case is discovered.


I'm sure a smarter person than me could write an event driven, real-time, web-enabled, protocol buffer communicating, graphical user interface, autonomous aircraft landing system for use in hurricanes using only SQL, but why would they?  You should use the best tool for the job.  If you can't correct the csv exporter to properly escape the data then you should properly escape the data manually or use a programming language that will make this task easier.

In my opinion, SQL is only going to make your life more difficult, and as such you should choose a different tool.