erich.schnepf at t-online.de
Sun Nov 4 22:48:26 CET 2007
forget Excel - in Access there are no problems with that matter; in Excel
there are no line breaks in the same cell, but checkbox-values - wich should
be in one line in a cell - are in a new record, when the line gets too long.
For databases we should use database-programs ;-).
In my case you are better off, when you use a database-program, because I use
the time-collision off for frame-events. So I have to connect several
databases for one querry.
Am Sonntag, 4. November 2007 21:03 schrieb Oliver Klee:
> Hi Erich,
> Erich Schnepf schrieb:
> > Line-break:
> > I have some (I think 4) checkboxes in the registration. They should be
> > in one line in the csv-export. Now I get a line-break. That means, that
> > f. e. one or more values from checkboxes are in a new line in a
> > excel-file, wich means that it is a data-record for itself.
> Actually, they are supposed to be on separate lines, but in the same
> cell (so there are line breaks in the cells).
> Generally, line breaks should be okay in CSV records if double quotes
> are used as field delimiters. Are you using double quotes as field
> delimiters in your CSV settings?
> I haven't been able to test with Excel, though, as I personally use
> OpenOffice.org. Could you please in Excel create a table that contains
> line breaks in a cell, export that as CSV and compare that format to the
> format created with the Seminar Manager CSV export?
> > It seems, that you cropped the line length - is that right?
> Um, where? What did I do? *confused*
> TYPO3-project-seminars mailing list
> TYPO3-project-seminars at lists.netfielders.de
More information about the TYPO3-project-seminars