Instead of Tab-delimited, look at CSV format. It supports embedded single- and double-quotes. And CSV imports into Excel. Embedded double quotes are two consecutive chars: ""
http://en.wikipedia.org/wiki/Comma-separated_values Bob -----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:30 To: 'U2 Users List' Subject: Re: [U2] Simple Export to Excel 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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
