Error IMporting data from .csv to mysql

[pilotjourney]

I am getting an error indicating that possibly an incorrect field delimiter is inb my .csv file. I searched the file with Excel looking for extra, "," & ";" but I still get an error indicating that there is some kind of unexpected field delimeter in the file.

Is there a way to "clean" a .csv file to make sure it is ready to be imported into a sql table?

Thank you

[Mittineague]

I wouldn't look for an "extra" delimiter, but for an "incorrect" delimiter. It might be something as subtle as a space. eg. "field1","field2" ,"field3","field4"
Maybe even a space before the newline that you can't see without "select" highlighting. Or maybe extra quotes eg. "field1","field"2"","field3"