I have a number of csv-files of different size, but all somewhat big. Using
Expecting 21 cols, but line 2557 contains text after processing all
cols. It is very likely that this is due to one or more fields having
sep=';'characters within unbalanced
cannot handle such ambiguous cases and those
lines may not have been read in as expected. Please read the section
on quotes in ?.
quote = ""
Solved this by installing SlickEdit and using it to edit the lines that caused the trouble. A few characters like ampersand, quotation marks, and apostrophes were consistently encoded to include semicolon - e.g.
& instead of just &. As semicolon was the seperator in the text document, this caused the problem in reading with