This took some tweaking of my test program, but I think with all the needed tests and data scrubbing, this is the way to go. It took some playing around with the commas and quotes (the raw data could have either or both of these conditions). It also deals with putting multiple lines in a single cell by enclosing that data in quotes, and putting the data on multiple lines. This looks goofy at first glance (putting 1 row of data on multiple lines), but it does work. Study the last example on the link below.
Thanks Bob. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bobby Worley Sent: Monday, June 22, 2009 10:44 AM To: 'U2 Users List' Subject: Re: [U2] Simple Export to Excel 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
