For that matter, why not go the XML route where you can define the column properties as well (at least I understand you can...). Makes the files a bit more swollen, but most excel's will load it up and parse it out properly.
George > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny > Sent: Monday, June 22, 2009 11:05 AM > To: U2 Users List > Subject: Re: [U2] Simple Export to Excel > > Make your data into an HTML table. > > Israel, John R. wrote: > > That would not work. We use double and single quotes in descriptions > for describing lengths. For example, we might sell something whose > dimensions are: > > 2"x3"x10' > > > > Even so, your info was helpful if I know my data will not have double > quotes. > > > > Anyone else have an idea? > > > > > > John Israel > > Sr. Programmer/Analyst > > Dayton Superior Corporation > > 721 Richard St. > > Dayton, OH 45342 > > 937-866-0711 x44380 > > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Edward Brown > > Sent: Monday, June 22, 2009 10:25 AM > > To: U2 Users List > > Subject: Re: [U2] Simple Export to Excel > > > > Dunno, how about converting double quotes in the data to single > quotes? > > Or stripping them out entirely? > > > > > > > > Ed > > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, > John > > R. > > Sent: 22 June 2009 15:22 > > To: 'U2 Users List' > > Subject: Re: [U2] Simple Export to Excel > > > > Cool. > > > > > > > > Here is the next wrinkle. What if my UniData data has (or may have) > > quotes in it? Am I out of luck or is there some alternate way to get > > the same result? Is there something like in other languages that you > > could convert double quotes in the raw data to "/q" or whatever, and > > Excel would know how to handle this? > > > > > > > > > > > > John Israel > > > > Sr. Programmer/Analyst > > > > Dayton Superior Corporation > > > > 721 Richard St. > > > > Dayton, OH 45342 > > > > 937-866-0711 x44380 > > > > > > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward > Brown > > Sent: Monday, June 22, 2009 9:58 AM > > To: U2 Users List > > Subject: Re: [U2] Simple Export to Excel > > > > > > > > Yes, if you quote-delimit all your fields then it's possible to pass > > > > @VMs as line feeds, and it will do what you want. > > > > > > > > Ed > > > > > > > > -----Original Message----- > > > > From: u2-users-boun...@listserver.u2ug.org > > > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, > John > > > > R. > > > > Sent: 22 June 2009 14:56 > > > > To: 'U2 Users List' > > > > Subject: [U2] Simple Export to Excel > > > > > > > > We have lots of programs that export our data from UniData to > > > > tab-delimited text files. Some of these are opened by Excel (which > has > > > > its faults), some are imported into other databases. These files > will > > > > be 1) E-mailed as attachments or written to specific location on the > > > > network. > > > > > > > > > > > > > > > > If I know that the users will always use Excel to open the > attachment, I > > > > usually make the file extension "xls" so that it simply fires up > Excel > > > > when double-clicked and parses everything out reasonably cleanly (but > > > > still drops leading zeros, converts big numbers to scientific > notation, > > > > etc). > > > > > > > > > > > > > > > > We are using UniData on HP-Unix. > > > > > > > > > > > > > > > > Is there a good way to convert @VMs to something that Excel will > > > > correctly convert to what would be equivalent to the Alt+Enter in > Excel? > > > > I do not want the data on multiple rows - I want multiple lines with > > > > breaks within a single row/cell. > > > > > > > > > > > > > > > > > > > > > > > > John Israel > > > > > > > > Sr. Programmer/Analyst > > > > > > > > Dayton Superior Corporation > > > > > > > > 721 Richard St. > > > > > > > > Dayton, OH 45342 > > > > > > > > 937-866-0711 x44380 > > > > _______________________________________________ > > > > U2-Users mailing list > > > > U2-Users@listserver.u2ug.org > > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > --------------------------------------------------------------------- > --- > > ------------------- > > > > Please remember to recycle wherever possible. > > > > Reduce, reuse, recycle, think do you need to print this e-mail? > > > > --------------------------------------------------------------------- > --- > > ------------------- > > > > This e-mail and any attachment(s), is confidential and may be legally > > privileged. It is intended solely for the addressee. If you are not > the > > addressee, dissemination, copying or use of this e-mail or any of its > > content is prohibited and may be unlawful. If you are not the > intended > > recipient please inform the sender immediately and destroy the e- > mail, > > any attachment(s) and any copies. All liability for viruses is > excluded > > to the fullest extent permitted by law. It is your responsibility to > > scan or otherwise check this email and any attachment(s). Unless > > otherwise stated (i) views expressed in this message are those of the > > individual sender (ii) no contract may be construed by this e-mail. > > Emails may be monitored and you are taken to consent to this > monitoring. > > > > > > > > Civica Services Limited, Company No. 02374268; Civica UK Limited, > > Company No. 01628868 > > > > Both companies are registered in England and Wales and each has its > > registered office at 2 Burston Road, Putney, London, SW15 6AR. > > > > --------------------------------------------------------------------- > --- > > ------------------- > > > > > > > > _______________________________________________ > > > > U2-Users mailing list > > > > U2-Users@listserver.u2ug.org > > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > ----------------------------------------------------------------------- > - > Jeff Schasny - Denver, Co, USA > jschasny at gmail dot com > ----------------------------------------------------------------------- > - > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users