Subject: Re: [U2] Simple Export to Excel
The csv 'standard' for fields containing a quote is double quote
So for the data
Col1 = col1data
Col2 = col 2 is here !, and it is good
Col3 = end
You have a csv of
col1,col 2 is here !, and it is good,end
Does the ! in front of the comma in Col2 make
-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: 06 July 2009 16:21
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
Excel has the nasty habit of doing things to the data. For example,
leading zeros are removed from numeric data. This is a bad thing
The csv 'standard' for fields containing a quote is double quote
So for the data
Col1 = col1data
Col2 = col 2 is here !, and it is good
Col3 = end
You have a csv of
col1,col 2 is here !, and it is good,end
Does the ! in front of the comma in Col2 make it escape the comma. In
other
There is a standard RFC4180 with iana. The standard is to have any commas
enclosed within the double quotes. Only the Double quotes are escaped with
double quotes.
hth
Colin Alfke
Calgary, Canada
From: Charles_Shaffer
The csv 'standard' for fields containing a quote is double
There is a standard RFC4180 with iana. The standard is to have any
commas enclosed within the double quotes. Only the Double quotes are
escaped with double quotes.
Got it. Thanks everyone. I didn't know that. I still think I'll stick
with tab delimiters though.
Charles Shaffer
Senior
charles_shaf...@ntn-bower.com wrote:
Got it. Thanks everyone. I didn't know that. I still think I'll stick
with tab delimiters though.
lol, standards are made to be broken :)
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
Got it. Thanks everyone. I didn't know that. I still think I'll
stick
with tab delimiters though.
lol, standards are made to be broken :)
We used to joke about the RS-232 'standard.' It was such a great standard
because there were so many different ways to implement it.
Charles
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Tuesday, July 07, 2009 1:51 PM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
Got it. Thanks everyone. I didn't know that. I
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:
Tab delimit4ed fiels work the same as comma delimited files as far as how
they handle quotes. And Excel will import
I second what Charles is saying. When moving data into Excel, tab-sep format
is a lot cleaner because you don't have to care whether a field has an
embedded comma, squote, or dquote.
-K
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
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 Kevin King
Sent: Monday, July 06, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
06, 2009 10:15 AM
To: 'U2 Users List'
Subject: Re: [U2] Simple Export to Excel
I agree completely. However, Excel has the nasty habit of doing things
to the data. For example, leading zeros are removed from numeric data.
This is a bad thing if you have valid data like 123, 0123 00123
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 George Gallen
Sent: Monday, July 06, 2009 10:35 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
I like
Excel has the nasty habit of doing things to the data. For example,
leading zeros are removed from numeric data. This is a bad thing if you
have valid data like 123, 0123 00123. Excel will make then all 123.
I agree. You can quote text values, but this is problematic if the data
itself
The problem with Excel stripping leading zeroes and converting stuff to
dates can be completely mitigated if you download and open the sheet
manually. If you open the sheet automatically, Excel does its magic.
However, if you open a .txt file with tabs (or even commas for that matter)
you can
King
Sent: Monday, July 06, 2009 8:34 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
The problem with Excel stripping leading zeroes and converting stuff to
dates can be completely mitigated if you download and open the sheet
manually. If you open the sheet automatically, Excel does
On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock lar...@wcs-corp.com wrote:
Or, you can create your export in the Office XML format, and tell excel
explicitly what to do with each column of data.
Absolutely. But what a time-consuming chore that can be... :-)
-K
ad (actually endorsement from happy user)
Which is why Tony G's NebulaXlite exists.
/ad
On Mon, Jul 6, 2009 at 9:54 AM, Kevin King precisonl...@gmail.com wrote:
On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock lar...@wcs-corp.com
wrote:
Or, you can create your export in the Office XML format,
The solutions provided here should help:
nospamNebula-RnD.com/blog/tech/2009/07/excel-csv1.html
From: John Israel
...Excel has the nasty habit of doing things to the
data. For example, leading zeros are removed from
numeric data. This is a bad thing if you have valid
data like 123,
I have a little ODBC project that I just started. Getting the IBM-U2
ODBC Driver to work with Excel was almost painless.
--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
: Monday, July 06, 2009 12:55 PM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock
lar...@wcs-corp.com wrote:
Or, you can create your export in the Office XML format, and
tell excel
explicitly what to do with each column of data
@listserver.u2ug.org
Subject: Re: [U2] Simple Export to Excel
As Robert describes, double quotes are used in freeware I've
published called ExcelExport, which exports full workbooks and
individual worksheets to CSV. You can get the software from our
freeware page and see the TXT Readme for details
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
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
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
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
: [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
...@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:
2x3x10'
Even so
: 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 [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
...@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
-
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
quote who='Steve Romanow' date='Monday 22 June 2009'
I am using pyExcelerator to make native xls files on aix. I think this
package is depracated and has been replaced by xlrd and xlwt. My use is
not mature at all, but I envision a hook in Output.Redirect that will
allow direct to xls
Do you have yours tied into SB+ at all? That is the holy grail.
Jeff Butera wrote:
quote who='Steve Romanow' date='Monday 22 June 2009'
I am using pyExcelerator to make native xls files on aix. I think this
package is depracated and has been replaced by xlrd and xlwt. My use is
not
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
-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
...@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
quote who='Steve Romanow' date='Monday 22 June 2009'
Do you have yours tied into SB+ at all? That is the holy grail.
No.
--
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
jbut...@hampshire.edu
413-559-5556
Dad, you're talking in grown-up and need to stop.
: 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
Steve;
SB+ downloads quite nicely to Excel. Query reports handle it natively (even
to 12 different graph types). Plus there is the TU.TO.EXCEL routine you can
look at if you want more explicit control. Primarily, it dumps it to a local
file, opens it with Excel and runs macros on it.
Hth
Colin
It requires sbclient and windows. I use neither.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/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
Please also consider NebulaXLite to create nicely formatted
spreadsheets for Excel, OpenOffice, and Google Docs. When you
deliver CSV in response to a request for Excel, it's like
introducing someone to their new business software that looks
like DOS. It just makes the business software seem
Wasn't your question about tying it into SB+? If you exclude the SBClient
portion of SB+ then how is it different from anything else? Whether you use
something like NebulaXLite to generate the document at the Basic level or
something server side like perl or python there shouldn't be anything
Colin,
I would like to to tie in to SB+ (as in an option available in
OUTPUT.REDIRECT). I think OUTPUT.REDIRECT is a prelude specific
routine, I may be wrong.
Where I make the distinction is I do not want to involve any DDE or COM
to the client, I would just liek the xls dropped to a dir
As Robert describes, double quotes are used in freeware I've
published called ExcelExport, which exports full workbooks and
individual worksheets to CSV. You can get the software from our
freeware page and see the TXT Readme for details.
no.spam.pleaseNebula-rnd.com/freeware/
Rather than making
46 matches
Mail list logo