Since I have no idea how other folks may be using the exported data, I don't dare change the description. Visually, it is no big deal (and might not even be noticed), but if they are trying to match something up between systems, and I have changed the text of one of these, then what used to line up will not.
I do not want to explain to senior management why some external process that worked flawlessly for years suddenly stopped working. 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 Steve Romanow Sent: Monday, June 22, 2009 11:45 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel John, Somehting I do for some extracts is replace " with IN and ' with FT in description data. Israel, John R. wrote: > 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: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] 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 > 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
