At 20:18 15/02/2009 +0200, Dotan Cohen wrote:
I am attaching a version of the file with classified information removed. It is UTF-8 text, and contains characters outside ASCII (Hebrew letters). I have verified that other Hebrew CSV files do in fact import properly, however. [...] here is the file on my server:
When I import this file, the problem seems to be that some rows do not terminate properly, so that the subsequent data continues beyond the columns that your column labels suggest it should use. The sheet expands to the maximum number of columns, and this seems to be what tips off the problem, despite what the error message says.
I don't read Hebrew and I cannot speak for your locale settings, but there appear to be characters among the Hebrew that my system, at least, is reading as double-quotes. This immediately upsets the structure of the comma-separated value file, of course - so that each row does not terminate properly. If I excise these characters (from rows 8, 31, 69, and 96 at least, I think), the file will open in Calc apparently correctly.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
