On Mon, October 6, 2008 05:33, Antal wrote: >> >> It is a plain text file, each row is separated with CRLF (#13#10), each >>> cell separated with tab (#9) >>> >> >> errm, surely that should be a comma, not a tab! > > > The Tab as separator is just a good way to avoid using the double quote :P > It just comes from the good old Lotus123. > Anyway, just try to copy/paste to a notepad from an Excel and you will see > how it works. > And then, saved as .CSV reopen it with Office and it might work. Or it > might > not :P > I am currently using this, since it is easier to manage as the double > quotes.
An additional issue with delimiters in this case is the fact, that "C" in "CSV" may not always be a comma (or that spreadsheet applications may expect different characters depending on locale - e.g. semicolons, etc.). Tomas _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
