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
