RE: [U2] String compare anomaly {Unclassified}

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-u2ug [EMAIL

Re: [U2] String compare anomaly {Unclassified}

] 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 usage has always been 1.234,56 while British usage was 1,234.56. Our

Re: [U2] String compare anomaly {Unclassified}

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:

Re: [U2] String compare anomaly {Unclassified}

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 PROTECTED] writes american

Re: [U2] String compare anomaly {Unclassified}

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 it

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 usage has always been 1.234,56 while British usage was 1,234.56. Our usage has changed to 1 234.56

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 definition. The Basic language is effectively typeless though it is more correct to say that it is

Re: [U2] String compare anomaly {Unclassified}

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

RE: [U2] String compare anomaly {Unclassified}

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 than how

RE: [U2] String compare anomaly {Unclassified}

@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 THEN ... treat the two items as unequal as they are strings. The answer to this comes from the language definition

RE: [U2] String compare anomaly {Unclassified}

, 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 0)' work properly? [I can sort of understand

RE: [U2] String compare anomaly {Unclassified}

, 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 THEN ... treat the two items as unequal as they are strings. The answer to this comes

RE: [U2] String compare anomaly {Unclassified}

. -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 tests found that *embedded* spaces didn't

RE: [U2] String compare anomaly {Unclassified}

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 notation

Re: [U2] String compare anomaly {Unclassified}

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

RE: [U2] String compare anomaly {Unclassified}

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

RE: [U2] String compare anomaly {Unclassified}

, 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: [U2] String compare anomaly {Unclassified} Mike, I have to code 'if (TheField eq

Re: [U2] String compare anomaly {Unclassified}

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't