What purpose will the OCONV(var,"MD0") serve?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley
Sent: Tuesday, May 07, 2013 6:06 PM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, curso
George,
After sending it I thought, "Well,... that OCONV acomplishes nothing!"
Dale
On 05/08/2013 08:32 AM, George Gallen wrote:
What purpose will the OCONV(var,"MD0") serve?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] O
The only thing I could think of is it could validate it as being a number, but
then
So would NUM().
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley
Sent: Wednesday, May 08, 2013 9:37 AM
To: U2 Us
It doesn't do nothing - it rounds - if the input value is 55.5 you get 56 as
output. It only does nothing if your input is a whole number.;
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley
Sent: Wednesda
Yes, it would do that. Have to keep that one in mind, instead of the old
INT(#+.5) if going to a whole number
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Wednesday, May 08, 2013 9:40 AM
To: U2 U
Dave,
I guess you're right, I originally stated it because the ICONV/OCONV is
just a standard method I use for rounding to shorter decimals. When I
started Pick, I found so many ways to do things that I usually adopted
one and from there on it's just repetition until you discover a problem.
NUM() will validate '' (null string) as numeric, and I believe some
implementations would validate '.' (decimal point) as numeric, although
the version of Jbase I'm on, running Universe emulation, does not.
Charlie
On 05-08-2013 8:39 AM, George Gallen wrote:
The only thing I could think of is
I Usually use NUM(xx) and xx#"" to combat that one.
Never really thought about "." - I would think that would be treated as 0.0 in
any calculations?
Guess I'll have to test that one out...
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@lis
VAR 0 rounds to a whole number just as OCONV(VAR, 'MD0') does. If you
want to drive the next programmer who comes along absolutely nuts, you
could use that. ;)
Charlie
On 05-08-2013 8:45 AM, George Gallen wrote:
Yes, it would do that. Have to keep that one in mind, instead of the old
INT(#+.
I normally use VAR MATCHES '1N0N]1N0N"."1N0N' where ] is a value mark.
Different strokes, I guess. There are many ways to skin a cat, but no
matter which one you use, the cat ain't gonna like it.
Charlie
On 05-08-2013 9:38 AM, George Gallen wrote:
I Usually use NUM(xx) and xx#"" to combat tha
Not to be too obtuse, but if the only point is to convert MM.MM to
you could just use CONVERT "." TO ""
-Original Message-
From: Charlie Noah
To: U2 Users List
Sent: Wed, May 8, 2013 7:34 am
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XM
That wouldn't work however, for say:
123.45 and MD3 conversion
You would get 12345 instead of 123450
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, May 08, 2013 12:08 PM
To: u2-us
Yes but the original request was just to take MM.MM and write
-Original Message-
From: George Gallen
To: U2 Users List
Sent: Wed, May 8, 2013 9:11 am
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
Same thing...
12.2 would give 122 instead of 1220
To not take into account dropped trailing zeros would be badalmost as bad
(well maybe worse)
Than a goto?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wj
Haha yes, but again, the original request...
If a client sent me "dollar" figures where 12.2 was supposed to mean 12.20 I
would go like ... what kind of system do you run where 12.2 means 12.20 ?
I'm assuming that a file you want to read into a Pick system, with embedded
MM.MM dollars is coming
They call it Excel!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, May 08, 2013 12:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Soc
No when I tell Excel that a column is dollars, or time, it always leaves
the trailing zero.
What are you doing that makes it remove that?
-Original Message-
From: George Gallen
To: U2 Users List
Sent: Wed, May 8, 2013 9:36 am
Subject: Re: [U2] Illegal use of the file, selec
Actually, Excel does NOT keep the trailing zero, but simply displays it that
way. The underlying data (what you get if you retrieve the data from the cell
programmatically) is "12.2". Or worse, it could be the result of a division,
and you could get 12.20333, but you told Excel to displ
That's assuming you are the one who created / imported the data into Excel.
However, I receive Excel files very frequently where the user who created it
Has little knowledge of formatting cells.
So very often I am forced to import data with dropped trailing zeros.
That and phone numbers being con
You have obviously never watched "Are you smarter than a 5th grader?"!
I wouldn't write off those gradeschoolers quite yet.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Wednesday, May 08, 201
But the problem is that those 5th graders are already programming! They "get"
number theory (better than some of us) and they "get" that 12.2 is the same as
12.20. When you tell them that your program can't handle real numbers, they'll
look at you with a look that says "Boy, these old guys are
Are you implying that I program like a fifth grader?
-Original Message-
From: Robert Houben
To: U2 Users List
Sent: Wed, May 8, 2013 10:17 am
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
But the pro
Do you find yourself talking like Jeff Foxworthy??
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, May 08, 2013 1:21 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Illegal use of the
You know you're a red-neck 5th grader when
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, May 08, 2013 10:28 AM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select,
On 08/05/2013 18:11, George Gallen wrote:
That's assuming you are the one who created / imported the data into Excel.
However, I receive Excel files very frequently where the user who created it
Has little knowledge of formatting cells.
So very often I am forced to import data with dropped trail
> From: Wjhonson
> I'm assuming that a file you want to read into a Pick system, with
> embedded MM.MM dollars is coming from an outside source. I can't
> recall ever seeing 12.2 used for 12.20 outside of a Pick system.
This is weird, I've seen a few discussions within the last week where
people
var = int(var * 100)
Nick Tilstra
-Original Message-
From: dale kelley [mailto:dalekel...@dalewkelleyinc.com]
Sent: Tuesday, May 07, 2013 6:06 PM
To: U2 Users List
Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,
XML, SCTX , MQS, SOAP or database variable.
You can create a custom format in Excel containing a zero mask of how
ever many characters you like and that will preserve (well, actually
replace the already stripped) leading zeros.
Anthonys Lists wrote:
With our phone numbers ... we are forced to use a database that
exports to excel ...
A
There are a couple ways to prevent automatic numeric reformatting in
Excel:
1) Any value preceded by a single quote is not treated as a number and
is thus not reformatted. So a telephone number becomes '123-456-7890.
2) If the document is real Excel and not just CSV rendered in the
Excel applica
29 matches
Mail list logo