To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76874
------- Additional comments from [EMAIL PROTECTED] Thu May 3 18:35:25 +0000 2007 ------- This is probably NOT valid CSV. The ERROR is probably invalid. For details about the CSV-format, see e.g. http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs (actually the wgole document is interesting). 1.) Fields that contain double quote characters must be surounded by double-quotes AND the embedded double-quotes MUST each be represented by a pair of consecutive double quotes - this csv-file contains lots of fields like the following one: ...;"some text"> more text"even more text";... those inner quotes are probably invalid 2.) Fields that contains embedded line-breaks must be surounded by double-quotes - this csv-file contains many lines that contain an ODD number of quotes, therefore, the filed DOES NOT end on that line, but would extend on the next line until an ending quote is reached!!! see e.g. line 184 in the original csv-file: - it contains 21 quotes I will append a simple gawk-script that can be used to detect lines with an ODD-number of quotes, therefore these are probably INVALID CSV-Files (IF one line is supposed to be equivalent to ONE record)! --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
