Thanks for the pointers,
Sorry i mislead you a bit - when i tried this myself it does indeed work if
you come out of udt and run it, it is only if you shell out from within udt
that it fails.
The set command before and while in udt shows quite a few diffs, these
mainly look to be udt config
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
You may want to check the ulimit for the user. Shell down to Unix and perform
a ulimit -f this will tell you if there is a max file size set on this specific
user.
Dan Goble
Sr. Programmer Analyst
RATEX Business Solutions, Inc.
-Original Message-
From:
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. Excel will make then all
123. Sure, I can put quotes around them, but when the
I like the = method, =1234567890,=001234,=01234,=1234
Will cause the import to treat as literalswhich might be a downside.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Monday, July
The problem is, Excel actually stores it with the equals and quotes. At a
glance, it looks good, but again, it can cause some grief with pivot tables and
when bounced against other Excel worksheets that have true data.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard
Yes that is the one - ulimit -f is unlimited but when i shell out of udt it
is set to 2gig, so i just need to reset this in my command
So from tcl i have
!ulimit -f unlimited;unzip UPLOAD/000855.zip
And this works ! :)
Thanks.
-Original Message-
From:
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
Or, you can create your export in the Office XML format, and tell excel
explicitly what to do with each column of data.
Larry Hiscock
Western Computer Services
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin
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,
Symeon:
Would you consider this a bug? I wonder if the same problem exists on
Windows?
Bill
Symeon Breen said the following on 7/6/2009 8:07 AM:
Yes that is the one - ulimit -f is unlimited but when i shell out of udt it
is set to 2gig, so i just need to reset this in my command
So from
Bill Haskett wrote:
Symeon:
Would you consider this a bug? I wonder if the same problem exists on
Windows?
Bill
Symeon Breen said the following on 7/6/2009 8:07 AM:
-Original Message-
From: Symeon Breen syme...@gmail.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent:
I'm on UV 10.0.2 on Redhat,
I did a shell, and my ulimit was unlimited.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Monday, July 06, 2009 1:57 PM
To: U2 Users List
Subject: Re:
Not sure it is a bug TBH , i presume the shell is inheriting the settings
from the udt shell above it.
If at bash i do ulimit -f 1000
Then do another shell (type sh) and do ulimit -f it says 1000 so ulimit does
seem to be inherited. Ofcourse udt is changing it from its parent shell i
assume
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
Group (I didn't see who the OP was),
I have a perl script/unidata program which will do XLS (Excel 2003 and
before). It requires that perl be installed and a few *excel.ppms* freely
available. The black box unidata driver program handles column heading,
formatting, justification, sorting,
I try to use UODOTNET OpenSecureSession method to open a SSL secure session.
I use self-sign certificate and get the following error message:
IBM U2UODOTNET - UNICLIENTErrorCode=39202 Unknown Error 39202 Occurred at
IBMU2.UODOTNET.UniObjects.OpenSecureSession(String hostname, Int32 port,
String
Hello all.
I have been working through some performance issues with a customer of ours,
and naturally have been looking at what changes are possible in the UniVerse
configuration.
At present I am looking to better understand the SCRMIN, SCRMAX and SCRSIZE
parameters.
I understand these
22 matches
Mail list logo