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;"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. 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]
