I'll try this method. I do beaucoups of downloads.
Thanks
- Original Message -
From: Symeon Breen [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, February 13, 2008 10:42 AM
Subject: RE: [U2] Excel downloads
Instead of 07748,012345,000123 have =07748,=012345,=000123
as Fred is okay.
Thanks
- Original Message -
From: Bessel, Karen [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, February 13, 2008 11:43 AM
Subject: RE: [U2] Excel downloads
I have had similar problems with Excel in the past.
Have you tried importing the column
[EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, February 13, 2008 12:00 PM
Subject: RE: [U2] Excel downloads
Comma delimited fields are always a bit of an issue in this case. The
correct way to program CSVs is to place quotes around the fields, to
account for just
Laure
Then it sounds like you could do the option described in these posts
For those who are lazy to write fancy routines to create CSV files, I've
created two dict items, namely COMMA and QUOTE, as follows:
COMMA
001: I
002: ,
003:
004: ,
005: 1T
QUOTE
001: I
002: ''
003:
004:
005:
Laure,
You can also use a PERL interface to create/read excel spreadsheets on the
SERVER without the need to have any Microsoft Excel components installs. This
is a nice cross platform solution. Of course, you must have Perl installed on
the server, but, this is trival in most cases. I
-
From: David Murray [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, February 12, 2008 4:40 PM
Subject: RE: [U2] Excel downloads
Laurie,
For simple totals, it is possible to add an EXCEL formula into a cell by
starting the cell/formula with an '=' sign. This also works with CSV
. For the titles
and subtitles it merges and centers cells using col-span...
Craig McDonald
Gensco
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Murray
Sent: Tuesday, February 12, 2008 1:40 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2
: [U2] Excel downloads
Laure
Then it sounds like you could do the option described in these posts
For those who are lazy to write fancy routines to create CSV files, I've
created two dict items, namely COMMA and QUOTE, as follows:
COMMA
001: I
002: ,
003:
004: ,
005: 1T
QUOTE
001: I
002
Instead of 07748,012345,000123 have =07748,=012345,=000123??
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: 13 February 2008 14:05
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
On this topic, I have
Yes, =002536 will stay as 002536 when opening the csv file with Excel
instead of importing it.
-Original Message-
From: MAJ Programming [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 13, 2008 8:05 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
On this topic
: Wednesday, February 13, 2008 8:05 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
On this topic, I have a request for a solution.
In New Jersey, all the zip codes start with '0'. Add product codes like
012345 and order numbers like 000123 etc and you'll see the leading
zeros
AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
On this topic, I have a request for a solution.
In New Jersey, all the zip codes start with '0'. Add product codes like
012345 and order numbers like 000123 etc and you'll see the leading zeros.
When creating and exporting
-556-9204
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis
Sent: Wednesday, February 13, 2008 7:36 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads
What if the data fields contain quotes or double-quotes
.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
Sent: Wednesday, February 13, 2008 12:01 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads
Comma delimited fields are always a bit of an issue in this case. The
correct way
David wrote:
Getting info into MS-Excel has always been an issue - careful
use of the XML in U2 and MS-Excel may hold the key...
Mmmm, worthy of an article...
Karen wrote:
Have you tried importing the column as text?
Sometimes that works sometimes it doesn't. Excel is a very
peculiar
] On Behalf Of IT-Laure Hansen
Sent: Thursday, February 14, 2008 4:01 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads
Comma delimited fields are always a bit of an issue in this case. The
correct way to program CSVs is to place quotes around the fields, to
account for just
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
IT-Laure Hansen
Sent: Tuesday, February 12, 2008 9:10 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Excel downloads
Hello,
We are looking for a simple way to drop aggregate totals type
Sent: Tuesday, February 12, 2008 3:36 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
Laure,
MITS Reports does export detail-suppressed information to an Excel
spreadsheet.
Just
- click on column heading, then
- click Display Totals, then
- add a break on the field you
@listserver.u2ug.org
Sent: Tuesday, February 12, 2008 7:32 PM
Subject: RE: [U2] Excel downloads
Hi Louie,
You are correct, it does - however I am dealing among others with a set
of files that contain about 85000 individual records: too much for Excel
in the first place, and also, updating the MITS data
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
Sent: Tuesday, February 12, 2008 7:32 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads
Hi Louie,
You are correct, it does - however I am dealing among others with a set
of files that contain about 85000
Bergsagel
Sent: Tuesday, February 12, 2008 3:36 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
Laure,
MITS Reports does export detail-suppressed information to an Excel
spreadsheet.
Just
- click on column heading, then
- click Display Totals, then
- add a break
NebulaXLite was developed to solve exactly the problem that you describe.
Please feel free to download and use a free trial:
remove.pleaseNebula-RnD.com/products/xlite.htm
For Excel back into U2, we have another option coming soon. The difference
between this and the AccuTerm option is that (1)
I use Accuterm FTD to create excel files and then run scripts via Accuterm
(PRINT ESC : STX : 'P' : SCRIPT : CR :) to create pivot tables for some of
my users.
Bruce
Bruce M Neylon
Health Care Management Group
IT-Laure Hansen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/12/2008 12:10
If this is a one-off type of job*, sometimes the simplest thing to do is
capture the screen output as a .txt file, then import to excel as fixed
length fields. Quick and dirty? Yes, but his would work pretty well for your
detail-suppress requirement. I use BREAK-ON fieldname 'L' to remove the
Laurie,
For simple totals, it is possible to add an EXCEL formula into a cell by
starting the cell/formula with an '=' sign. This also works with CSV
structured files, which EXCEL will load and convert on the fly.
Create a virtual/correlative field which will simply output the formula as
text
Sent: Tuesday, February 12, 2008 11:42 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure
Hansen
Sent: Tuesday, February 12, 2008 9:10 AM
To: u2-users@listserver.u2ug.org
Hi Laure,
I used a simple technique for this a while back.
Create a program and EXECUTE the retrieve statement and CAPTURE the
output.
If you add Char(9) to a dict and place this between each field excel
will then split it in to columns.
EG
SORT FILE BY FIELD1 BREAK.ON FIELD1 TAB
27 matches
Mail list logo
