On Sunday, July 29, 2012, Robert Brenstein wrote: > On 29.07.2012 at 9:05 Uhr -0700 Dr. Hawkins apparently wrote > > If you deal only with dollars, the issue is trivial. Things get quickly > complicated if you deal with multiple currencies. >
Trivial would be good :) Yes, only dollars; this is for us bankruptcy filings, so it has no extra national implication. If I store In pennies . . . (pull theVal from the db as an integer) put (theVal<o) into isNeg replace "-" with empty in theVal if len(theVal) =1 then put 0 before theVal put "." before char -2 of theVal If len(theVal) >6 then put comma before char -6 of theVal If len(theVal) > 10 then put comma before char -10 of theVal If len(theVal) > 14 then put comma before char -14 of theVal put "$" before theVal If isNeg put "-" before theVal but it sure seems clumsy, and that I should simply be able to put something like format("-$,#.00", theVal) and let the engine handle it in a fraction of the time. -- The Hawkins Law Firm Richard E. Hawkins, Esq. (702) 508-8462 hawkinslawf...@gmail.com 3025 S. Maryland Parkway Suite A Las Vegas, NV 89109 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode