-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anthony W.
Youngman
Sent: Thursday, July 07, 2005 05:21 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] String compare anomaly {Unclassified}
In message <[EMAIL PROTECTED]>,
gerry-u2ug <[EMAIL PROTE
All,
Appears to be a South African thing. Here's some pages with '1 000'
format.
http://www.news24.com/News24/World/Iraq/0,,2-10-1460_1638695,00.html
http://www.news24.com/News24/South_Africa/Aids_Focus/0,,2-7-659_1730422,00.html
And one from England to murk up the matter:
http://www.o
r.u2ug.org
Subject: Re: [U2] String compare anomaly {Unclassified}
In message <[EMAIL PROTECTED]>,
gerry-u2ug <[EMAIL PROTECTED]> writes
"american notation is to use a space as a thousands separator" - on
which planet is that ?
Apologies if I'm wrong, but European
s 123 456.89
Gerry
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anthony W.
Youngman
Sent: Thursday, July 07, 2005 05:21 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] String compare anomaly {Unclassified}
In message <[EMAIL PROTECTED]>,
gerry-u
In message <[EMAIL PROTECTED]>,
gerry-u2ug <[EMAIL PROTECTED]> writes
"american notation is to use a space as a thousands separator" - on
which planet is that ?
Apologies if I'm wrong, but European usage has always been 1.234,56
while British usage was 1,234.56. Our usage has changed to 1 234.
In message <[EMAIL PROTECTED]>, Martin Phillips
<[EMAIL PROTECTED]> writes
(by the way, Martin, our tests found that *embedded* spaces didn't affect
numericity. Indeed, they shouldn't, because ?American? notation is to use a
space as a thousands separator)
Interesting I just tried this and
I wondered about that at least 1,000.00 times ;-)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug
Sent: Wednesday, July 06, 2005 14:30
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] String compare anomaly {Unclassified}
"american notati
up but
afaik it is total bunk.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Martin Phillips
Sent: Wednesday, July 06, 2005 12:46 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] String compare anomaly {Unclassified}
> (by the way, Martin, our t
From: Martin Phillips [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 06, 2005 2:52 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] String compare anomaly {Unclassified}
>
> No one seems to have answered the underlying question to this thread. Why
> doesn&
to:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE,
MR
Sent: Tuesday, July 05, 2005 20:16
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] String compare anomaly {Unclassified}
All right, Craig, there are other alternatives that _will_ work. :-)
But why doesn't 'if (TheField eq "00
> (by the way, Martin, our tests found that *embedded* spaces didn't affect
numericity. Indeed, they shouldn't, because ?American? notation is to use a
space as a thousands separator)
Interesting I just tried this and it doesn't work. My test was simple...
a = '123 456'
b = '123456'
c
TECTED]
> Sent: Wednesday, July 06, 2005 2:52 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] String compare anomaly {Unclassified}
>
> No one seems to have answered the underlying question to this thread. Why
> doesn't
>IF "0" = "00&quo
Consider:
IF "-2 500.15" > "3" THEN
There are some "non-numeric characters" that you will occasionally want
to use with a numeric comparison.
That being said - UniData (5.1.27 and 6.0.12 on Windows) uses a string
compare when there is a space in one of the values, this appears to be
different th
> That makes sense. But what about when the space is added? It is no longer
a number, but yet it is still doing a numeric comparison.
The definition also says that leading and trailing spaces are ignored when
trying to convert strings to numbers.
Martin Phillips
Ladybridge Systems
17b Coldstream
Subject:Re: [U2] String compare anomaly {Unclassified}
No one seems to have answered the underlying question to this thread. Why
doesn't
IF "0" = "00" THEN ...
treat the two items as unequal as they are strings.
The answer to this comes from the language definiti
No one seems to have answered the underlying question to this thread. Why
doesn't
IF "0" = "00" THEN ...
treat the two items as unequal as they are strings.
The answer to this comes from the language definition. The Basic language is
effectively typeless though it is more correct to say that it
But why doesn't 'if (TheField eq "0")' work properly?
[I can sort of understand this being mis-recognised as a numeric
compare]
Or 'if (TheField:" " eq "0 ")' ?
[Now that really should work, in my view, but it doesn't]
Sorry Mike :) I was in helpful but thoughtless mode, didn'
x27; ?
[Now that really should work, in my view, but it doesn't]
Mike
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett
> Sent: Wednesday, 6 July 2005 14:30
> To: u2-users@listserver.u2ug.org
> Subject: Re
Checkout the COMPARE() function in HELP
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE,
MR
Sent: Wednesday, 6 July 2005 9:56 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] String compare anomaly {Unclassified}
When I do a compare, "0"
Mike,
I have to code 'if (TheField eq "0") and (len(TheField) eq 5) then
How about:
if (TheField MATCHES "5N") AND (TheField eq 0) then
or
if (TheField MATCHES "'0'") then
Craig
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver
20 matches
Mail list logo