On Sunday 23 January 2005 22:06, Brian wrote: > Jerry Westrick wrote: > >Dear Users: > > > >Is it just me or does OO not accept Multi-line Cells in CSVs? > > > >Example: > > > >comp_1;mlshist;"1 MLS entries found: > >The comparable sold for 180000 on 1997-07-30 (mlsnum: 122293)" > > > >The above 2 lines, should be give 1 row with 3 cells, the last cell having > > 2 lines... > > > >Unfortunately, OO gives me 2 rows. > > Hi Jerry, > If I make a new text doc with your data exactly as shown here (on two > lines) then I get two lines in the spreadsheet. > If I make the doc with one line only (as I would expect in the CSV file) > and open it a a colon separated CSV(.txt) file I get only one line. > Please post the CSV file to a website where we can check it's exact > contents, or email me a copy of it direct - this list will strip > attachments. >
ahh brian.. If you notice, that the Quote value has no ending on line 1, therefore the value includes the <cr>, and should thefore insert the <cr> into the 3rd cell as if you entered <ctrl><cr> giving you 2 lines in Cell 3 instead of a second row. The 2 lines where quoted verbatim, just take of the >> at the begining... Jerry P.S. Excell does just that... > Brian --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
