Is there any way to get DBManSQL to display commas in a price field?

A price of $500,000 is much easier to read than $500000.

If it's possible what would be required?



Thanks

Try create a global template called 'format_usd':

sub {
my ($name) = shift;
my $tags = GT::Template->tags;
my $value = $tags->{$name};
my $dol_str = reverse sprintf( "%.2f", $value );
$dol_str =~ s/(\d\d\d)/$1,/g;
$dol_str =~ s/,$//;
$dol_str = $dol_str . "\$";
return scalar reverse $dol_str;
}

Now you can use <%format_usd('variable_name')%> in the template

TheStone.

B.

Works perfectly!



Thanks

Hello

How can I format the results for Money in this way

R$ 0.000.000,00

at each group of 3 numbers show a point?

And how the regex would be?

Thanks

Fábio

try to change the global a little bit and the regex could be like below :



Cheers,
Jean
Gossamer Threads, Inc.