[Robelle-l] Calling all keeners

[Neil Armstrong]

At 12:39 PM 4/14/2003 -0400, Pickering, John (NORBORD) wrote:
I have changed the "editing" of the number, such that if
the Thousandsymbol is set to space, Suprtool will not consider
a space in between numbers to NOT be an error. This should allow
those people who have numbers in the form:

123 456-
435 123+

to be converted by Suprtool.

Sincerely,


Neil armstrong

>Oops -- looks like I didn't read far enough -- the perils of lengthy mail
>messages :-)
>
>How about editing the string so that the thousand symbol must be followed by
>3 digits? Then "123 456" would be ok but 12345 6" would not.
>
>-----Original Message-----
>From: Neil Armstrong [mailto:neil@robelle.com]
>Sent: Monday, April 14, 2003 12:28 PM
>To: Pickering, John (NORBORD); 'robelle-l@robelle.com'
>Subject: RE: [Robelle-l] Calling all keeners
>
>
>At 12:15 PM 4/14/2003 -0400, Pickering, John (NORBORD) wrote:
>John,
>
>Actually I briefly mention it in the last paragraph, as it
>is the ThousandSymbol. A comma is essentially just stripped
>from the number. Same is true for the currency symbol. They
>are settable for other Currencies/formats etc. The only issue is that
>you cannot have spaces in-between numbers. Part of this
>trial is to see if that particular edit should be removed. It was
>mentioned to me, as a possible issue but I have to see the
>response and find the best solution based on that response.
>
>The concern was to provide the types of edits, where someone
>is trying to define a field and they miscount and end up with
>a number that looks like:
>
>12345 1
>
>where the 1 is the start of the next field.
>
>I can certainly either consider spaces be an error or not,
>or I can make it an option. Keep in mind that the more options
>you add the slower this function may be.
>
>The comma is simply stripped as there are no numeric data types
>that consider it a "legal" character. The function is called
>$number as it takes a certain defined space and tries to convert
>it to a number.
>
>Thanks for the great feedback. It is all stuff that I have thought
>of, but need feedback on.
>
>Sincerely,
>
>
>Neil Armstrong
>Robelle
>
> >Neil
> >
> >You don't say anything about commas. Will the function accept commas --
>e.g.
> >123,456.99 ?
> >
> >You might consider an enhancement to ignore commas (simply toss them away)
> >-- I get a lot of data from Excel and the users keep forgetting to remove
> >all the pretty formatting stuff so my Powerhouse conversion routines choke
> >since they don't like commas.
> >
> >And then the Quebec users are going to want to use spaces instead of commas
> >and commas instead of periods -- some sort of SI standard I think, or maybe
> >they're just exerting their usual "distinct" differences. Maybe European
> >customers will ask for something similar?
> >
> >Sorry if I've opened a can of worms :-)
> >
> >Regards,
> >JWP
> >
> >
> >-----Original Message-----
> >From: Neil Armstrong [mailto:neil@robelle.com]
> >Sent: Monday, April 14, 2003 11:47 AM
> >To: robelle-l@robelle.com
> >Subject: [Robelle-l] Calling all keeners
>
><original enhancement description snipped>