I'm trying to import this CSV file into MySQL that appears to be optionally enclosed by more than one character. Unfortunately, MySQL only supports one character as a field separator.
I am stuck doing this entire process in SQL as it is part of a larger program- so scripting is out of the question.
Example of the data:
reportdata, commission, total, chargeback, company ",123,""$116.00 "",""$604.00 "",""($88.00)"", foo
I'm stumped apart from attempting to do a bunch of string operations on a temp table.