Europe Vs. America

[Nonsanity]

Even printing money in English format (commas separating 1000's, period for
decimal) requires a homemade function for formatting. Here's one I threw
together for Euro format:


function PrintAsEuros x
   set itemdel to "."
   put item 2 of x into d[0]
   put 1 into a
   put trunc( x ) into x
   repeat until x is empty
      put char -3 to -1 of x into d[a]
      delete char -3 to -1 of x
      add 1 to a
   end repeat

   put "€. " into o
   repeat with b = a-1 down to 1
      put d[b] &"." after o
   end repeat
   delete last char of o
   put "," & char 1 to 2 of (d[0] & "00") after o

   return o
end PrintAsEuros


Nothing fancy, but it seems to work for me.

 ~ Chris Innanen
 ~ Nonsanity


On Thu, May 19, 2011 at 10:14 AM, Alessandro Pisoni <
alessandro at system-ini.it> wrote:

> how to format a currency column set as such. €. 1.200,00 formats European
> and not American? The data comes from a sqlite db
>
> if I insert the values in a column in the datagrid the values are wrong.
>
> is there a way to format a datagrid column format in Europe!
> Not all the world is American
>
>
>
> thanks
>
> Alex
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode