Répondre: RE: [Robelle-l] Calling all keeners
Kurt Sager
kurt.sager@sws.ch
Tue, 15 Apr 2003 8:00:46 GMT+1
Hi Neil,
>set decimalsymbol "."
>set thousandsymbol ","
>set currencysymbol "$"
1. set commands
can we do a
set currencysymbol "CHF"
(several characters) ?
can we
set decimalsymbol ","
(decimal point is a comma, usual notation in Germany for example!)
and this will overwrite the rule of stripping out any commas ???
2. rounding
Please note that in our country (of banks ...) the generally applied
rounding rule says:
- if the last digit to be rounded is a 5, then it is
rounded DOWN if the preceeding figures is EVEN
rounded UP if the preceeding figure is ODD
Examples:
1.245 --> 1.24
1.235 --> 1.24
total 2.480 --> 2.48
In fact, this rule avoids introducing a bias when a large number of
numbers have
to be rounded and then added to give a total.
If not everybody is happy with my rounding proposal then you might consider
a new
set swissroundingrule on ;-)
3. Diskussion about what to do with the "space character"
Why not changing, optionally, occuring spaces to a comma (thousand separator) ?
You might consider a more general command
set characterreplace "<cb(1)><cb(2)> ... <cb(n)>"<ca(1)><ca(2)>...<ca(n)>"
where
cb(i) and ca(i) are single charaters
cb(i) := character before replacement
ca(i) := character after replacement
and this setting will
cb(i) --> ca(i) for i = 1, ..., n (execution strictly in this order)
for all characters matching a cb(i) within the field to be treated,
leaving non-matching
characters unchanged.
Easier to implement would probably be
set keepspecialcharacters "."
which would remove (before the type conversion) all characters expect the
decimal point (and the figures 0 to 9 of course).
Kurt
"'robelle-l@robelle.com'" <robelle-l@robelle.com
Le Mon, 14 Apr 2003 12:27:35 -0400, Neil Armstrong a écrit:
> 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
> >
> >
> >Dear Robelle-L,
> >
> >We just finished a very interesting enhancement to
> >Suprtool, which we want some keen people to test for
> >us.
> >
> >The feature we want tested is a new function called
> >$number, which will take a free-form "number" and
> >use it as a display field.
> >
> >Here are the change notice docs to describe this
> >feature. If you are interested in trying this
> >feature out then please e-mail me back at neil@robelle.com.
> >
> >This is the last pre-release of Suprtool, prior to
> >production release for Suprtool 4.7. Here are the draft docs
> >for the new feature:
> >
> >$Number Function If and Extract
> >
> >Suprtool now has the ability to accept free-form "numbers" as
> >display data types. This means number in the form:
> >
> > 1234.45-
> > -12345
> > -123.2134
> > 12343
> > $123.45-
> >
> >can now be accepted and converted to any other numeric data type.
> >
> >Consider the following data:
> >
> > Item-number New-Price
> > 12345 +123.45
> > 34563 + 27.5
> > 21312 + 1.545
> >
> >Suprtool can now read and convert the data in New-Price using the
> >number function. Let's say we want New-Price to be a double
> >integer and currently occupies eight bytes starting in position
> >six.
> >
> >Here is the task you would use to convert the New-Price
> >free-format number into a double integer.
> >
> > >in mynums
> > >def item-number,1,5,byte
> > >def new-price-ascii,6,8,display
> > >def new-price,1,4,double
> > >item new-price-ascii,dec,2
> > >item new-price,dec,2
> > >ext item-number
> > >ext new-price=$number(new-price-ascii)
> > >out somefile,link
> > >xeq
> >
> >
> >The $number function take the free-format number and make it a
> >valid display number. It will determine the decimal, sign and add
> >leading zeroes. It will round the number to the defined number of
> >decimal places.
> >
> >In the case of 1.545 number, Suprtool will round the value to be
> >1.55, since the given number of decimal places is two and the
> >preceding value is five or greater. If you have a whole number
> >such as 54, with no decimal point the value becomes 54.00.
> >
> >Suprtool will not accept data that has:
> >
> > More than one sign.
> > More than one decimal place.
> > Spaces in between numbers.
> > Signs that are in between numbers.
> > Characters that are not over punch characters.
> > Fields that when edited do not fit in the defined space for the
> >display field.
> >
> >You can control the character that defines the currency, thousand
> >and decimal symbol for other currencies and formats using the
> >following commands:
> >
> > >set decimalsymbol "."
> > >set thousandsymbol ","
> > >set currencysymbol "$"
> >
> >Suprtool in the above case will strip the currency and thousand
> >symbols and use the decimal symbol to determine the number of
> >decimal places. You can set these characters to any values you
> >want but the defaults for each are used in the above set commands.
> >
> >Sincerely,
> >
> >
> >Neil Armstrong
> >Suprtool Architect
>
>
> _______________________________________________
> Robelle-l mailing list
> Robelle-l@robelle.com
> http://two.pairlist.net/mailman/listinfo/robelle-l
>
Mit freundlichem Gruss
Meilleures salutations
Best regards
Kurt Sager
CEO
--------------------------------------------------------------------------------------
Kurt Sager
SWS SoftWare Systems AG, av. de la Gare 7, C.P. 1413, CH-1701 Fribourg
SWS SoftWare Systsms GmbH, Traubengasse 19, DE-79552 Weil am Rhein
http://www.sws.ch
Phone: +4126 321 2942 Fax: +4126 321 2926
Support & Hotline: support@sws.ch
Product Infos : info@sws.ch
--------------------------------------------------------------------------------------