Re: Script to format a currency value

2011-03-02 Thread Peter Haworth
Yes, I was just thinking about that yesterday, plus sometimes negatives are shown in red. I'm leaning towards leaving it to the application that calls the formatting routine to deal with those options, mainly because the OS user preferences don't include a way to specify either the parentheses

Re: Script to format a currency value

2011-03-02 Thread Keith Clarke
Peter, I seem to recall that in accountancy, negative values can be shown in parentheses rather than using the minus sign, so (£1,234.56) = -£1,234.56. Just another variable! ;-) On 2 Mar 2011, at 01:33, Peter Haworth wrote: > Hi Alex, > To be honest, I'm not sure if there's a real life case

Re: Script to format a currency value

2011-03-01 Thread Peter Haworth
Hi Alex, To be honest, I'm not sure if there's a real life case for variable sizing of groups! I'm using the specs for the information returned by the Unix locale LC_MONETARY command and it specifically talks about the group spec this way. Seems unlikely but it adds to the spice of writing a

Re: Script to format a currency value

2011-03-01 Thread Alex Tweedly
I'm curious is there really a real-life use-case for the group spec ? i.e. variable size groupings of digits ? Not sure what order you want for currency and neg sign ? Should it be $-123 or -$123 and should it be 123-$ or 123$- ? Should there always be a 0 before the "point" ? i.e. c

Re: Script to format a currency value

2011-03-01 Thread Peter Haworth
Pictures please! Pete Haworth On Mar 1, 2011, at 9:11 AM, Bob Sneidar wrote: > Oh hell, I will just buy that outright! I love Celtic music and used to play > in a marching bagpipe band. And yes, I wore a kilt! I looked good in it too. > > Bob > > > On Feb 28, 2011, at 8:55 PM, Peter Haworth

Re: Script to format a currency value

2011-03-01 Thread Peter Haworth
Hi Sarah, Sorry for the confusion, bad terminology! You're right when you say it's just the currency value stored without the decimal point (although the number of implied decimal points is part of the formatting spec, not fixed at 2). I'll come up with some test cases today and send them in a

Re: Script to format a currency value

2011-03-01 Thread Bob Sneidar
Oh hell, I will just buy that outright! I love Celtic music and used to play in a marching bagpipe band. And yes, I wore a kilt! I looked good in it too. Bob On Feb 28, 2011, at 8:55 PM, Peter Haworth wrote: > OK, here's an amusing exercise in scripting for you experts out there, but > I'm gi

Re: Script to format a currency value

2011-03-01 Thread Sarah Reichelt
On Tue, Mar 1, 2011 at 2:55 PM, Peter Haworth wrote: > OK, here's an amusing exercise in scripting for you experts out there, but > I'm giving away a prize!  I will give the person who provides the best > solution a copy of my band's latest CD, Aged 10 years.  the definition of > "best" is stri