Adobe Forums wrote:
> It works from Monday - Saturday, but bombs on Sunday
> Message Incorrect number of columns in row.
> Detail Verify the number of columns specified in the
columns attribute and
> in the target file
i assume this question relates to your trying to read txt/csv
your db, right?
it then can mean:
a) depending on the way you read files into the db: that at
row of data has fewer or more items than expected (defined by
row or by some rule imposed by your code, like number of
columns of data
b) as in the googled explanation: that at least one of the
in the imported data has carriage returns stored in it, which
current data row with fewer data columns than expected.
i suspect that on sundays you get your data in a bit
than on other days...
one way to get around the problem (if you can't
model integrity) would be to
- read your data file in row by row
- in each row replace all carriage returns except the
- check each row for correct number of data columns: import
data if all
correct; otherwise do not import that row, store the row data
var/file and review later to see what was wrong with it