Data contains 1 columns, expected 27

[cloudyrobert]

I'm doing a data import from a CSV file on an FTP server.   The CSV is delimited using semicolons rather than commas, but is not otherwise out of the ordinary.   When I load the file, I get an error, "data contains 1 columns, expected 27".   The transforms run as they should, and the data comes into the system.   Why am I getting this error?

[cloudyrobert]

It doesn't look like the dates are the issue as I tested after removing them.   I can certainly see this resolving any issues with encoding, but this will be a nightly automated load, so no one will be touching the file before it is imported.

[cloudyrobert]

It appears to be caused by a comma within some of the data.   The semi-colon delimiter is working fine, but the comma is still being recognized as a special character...

[cjohnson]

To anyone coming here regarding this problem with seemingly nothing wrong with the data but you are still getting this error, try hitting the [view] link next to your attachment before attempting to load all records or test load 20 records. This workaround worked in the Istanbul version for me a couple times with very large data sets.

[Community Alums]

This seems related too: Importing CSV shows the error "data contains Y columns, expected Z