On 15 Mar 2005 at 21:19, Eric Wood wrote: > ----- Original Message ----- > From: "Tony Pursell" > > The truth is, this can be very hit and miss. Having a calc wiindow > > open might not guarantee that a CSV file will be opened in Calc. I > > have found that the CSV files created by the Mail Merge Wizard will > > NEVER get opened this way by Calc. That because they are malformed > > Unicode files. (There is an issue logged for this). So it may be > > that > the > > CSV file in question here has a similar problem. > > I've harped on this forever. Why people use CSV is beyond me. TAB > delimited file are much more safe to use - avioding the nested > quotations or comma character issues. >
Hi Eric The file produced by the Mail Merge Wizard was actually tab delimited with a csv extension, but that did not help to get it loaded into Calc. Personally I don't think tab delimited is much better than comma delimited. Data can still have embedded tabs so data still needs text qualifying quoted. I did a lot of work with delimited text files automatically merged in Word using macros and we chose the 'pipe' symbol (|) as a character most unlikely to occur in normal text. There has been a long running thread on the discuss list about this. If you are interested, have a look at that. Tony Pursell --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
