Hello Eike. This is the data http://www.openoffice.org/nonav/issues/showattachment.cgi/44736/Praha4.zip (attached to i31441) Make sure you leave " as text delimiter and set ; as separator.
This is the offending string (64939022;1995-12-18;;00;2005-09-08;112;519000;000;500119;CZ0104;"BROPEX trading s. r. o. ";"BROPEX TRADING,SRO,PHA;14000;Praha 4;Podolí;Jeremenkova 719/91;11003) After import Calc creates huge cell L8684 which contains many records at once. Regards, Kirill Palagin. -----Original Message----- From: Eike Rathke [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 4:38 PM To: [email protected] Subject: Re: [sc-dev] Question about OpenOffice.org Calc: CSV import enhancements Hi Kirill, On Monday, 2007-04-23 17:51:29 +0400, Kirill S. Palagin wrote: > Basically the problem boils down to not having text delimiter in pairs > (http://www.openoffice.org/issues/show_bug.cgi?id=31441). Based on your further description that seems to be yet something different though. Well, not much to say without having seen the data. > That other spreadsheet app handles this scenario by treating > everything between unmatched delimiter and next record separator as single > string. I tried to load this messy data "first field"x,y"second field" "third field","fourth field"extra "fifth field still the fifth" "sixth field"extra maybe seventh" into both, Excel and Calc, and they both came up with the same result. So your (respectively the OP's) case seems to be somewhat pathological.. > We are trying to search for matching text delimiter ignoring record > separators, so our behavior argurably can be improved. I wouldn't exactly call that improvement though. It would just introduce some more fuzziness to be able to read data written by applications that aren't able to properly write CSV. > Should I file RFE for that? Does it have any chance of being > implemented? Maybe somewhen.. it most certainly won't get any priority (let's see the data first though), but it would be good anyway to have that documented in an issue, with test case data. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. --------------------------------------------------------------------- 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]
