OK, fine, works for me. Thanks. > -----Original Message----- > From: Eike Rathke [mailto:[EMAIL PROTECTED] > Sent: Friday, April 27, 2007 10:42 PM > To: [email protected] > Subject: Re: [sc-dev] Question about OpenOffice.org Calc: CSV > import enhancements > > Hi Kirill, > > On Friday, 2007-04-27 18:14:16 +0400, Kirill S. Palagin wrote: > > > 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;"BROP > > EX 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. > > Which is perfectly correct. The field starting with "BROPEX > TRADING,SRO isn't closed with a matching quote and so > contains an embedded linefeed. > This is a feature of CSV, see also > http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs > > 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]
