Format a number as currency! I can't find any help on this simpleproblem.

[Richard Kessler]

I am relatively new to Python. Love it, but I find things that I can do
easily in .NET and cannot find a way to do in Python. I need to format a
number as currency, for example 12343.56 to $12,343.56.

In C# all I need to do is decimal x = 12343.56 then x.ToString("$## #,###.00");

I cannot find a way to do this in Python. I must be missing something very
simple here. I have tried the locale module but it will not put in the commas.
I hope I do not have to write my own formatting routine...surel y one is out
there and I just can't find it.

Running on XP Pro. Python 2.4.3.

Thanks much in advance,

Richard

[Bernard]

>>import locale

>>locale.setloc ale(locale.LC_A LL, 'English_United States.1252')

'English_United States.1252'

>>conv = locale.localeco nv()
x = 1234567.8
locale.format ("%d", x, grouping=True)

'1,234,567'

>>locale.format ("%s%.*f", (conv['currency_symbo l'], conv['int_frac_digit s'], x), grouping=True)

'$1,234,567.80'

Hi Richards,

This works for me. I agree it's a bit complicated compared to C# but it
works. I'd put it in a function if I had to use it.
Richard Kessler wrote:

I am relatively new to Python. Love it, but I find things that I can do
easily in .NET and cannot find a way to do in Python. I need to format a
number as currency, for example 12343.56 to $12,343.56.

In C# all I need to do is decimal x = 12343.56 then x.ToString("$## #,###.00");

I cannot find a way to do this in Python. I must be missing something very
simple here. I have tried the locale module but it will not put in the commas.
I hope I do not have to write my own formatting routine...surel y one is out
there and I just can't find it.

Running on XP Pro. Python 2.4.3.

Thanks much in advance,

Richard

[jr]

Hi, Bernard.
Just tried the first 2 commands on win XP, Python 2.5 under Idle.
An Error is raised: "unsupporte d locale setting" (lib/locale.py in
setlocale, line 476).
Actually I get the error also under Python 2.4.3
Any idea what I'm missing?
Thanks in advance.
Jürgen
Bernard wrote:

>import locale
locale.setloca le(locale.LC_AL L, 'English_United States.1252')

'English_United States.1252'

>conv = locale.localeco nv()
x = 1234567.8
locale.format( "%d", x, grouping=True)

'1,234,567'

>locale.format( "%s%.*f", (conv['currency_symbo l'], conv['int_frac_digit s'], x), grouping=True)

'$1,234,567.80'

Hi Richards,

This works for me. I agree it's a bit complicated compared to C# but it
works. I'd put it in a function if I had to use it.
Richard Kessler wrote:

I am relatively new to Python. Love it, but I find things that I can do
easily in .NET and cannot find a way to do in Python. I need to format a
number as currency, for example 12343.56 to $12,343.56.

In C# all I need to do is decimal x = 12343.56 then x.ToString("$## #,###.00");

I cannot find a way to do this in Python. I must be missing something very
simple here. I have tried the locale module but it will not put in the commas.
I hope I do not have to write my own formatting routine...surel y one isout
there and I just can't find it.

Running on XP Pro. Python 2.4.3.

Thanks much in advance,

Richard

[Jerry]

Replace the conv function call with locale.localeco nv.

--
Jerry

[Peter Otten]

jr wrote:

>>import locale
locale.setloc ale(locale.LC_A LL, 'English_United States.1252')

'English_Unite d States.1252'

Just tried the first 2 commands on win XP, Python 2.5 under Idle.
An Error is raised: "unsupporte d locale setting" (lib/locale.py in
setlocale, line 476).
Actually I get the error also under Python 2.4.3
Any idea what I'm missing?

Let your machine decide

>>locale.setloc ale(locale.LC_A LL, "")

'de_DE.UTF-8'

or try something less specific:

>>locale.setloc ale(locale.LC_A LL, "en_US")

'en_US'

Peter