Thousand separator

[ReFran]

Hi,

perhaps someone can help.

With

stringformat("%.f", $value)

I can set the decimalplaces to .xx, but how can I set a thousand separtor x,xxx.xx ?

Do I have to use a for loop?

Best regards, Reinhard

[PsaltyDS]

Hi,

perhaps someone can help.

With

stringformat("%.f", $value)

I can set the decimalplaces to .xx, but how can I set a thousand separtor x,xxx.xx ?

Do I have to use a for loop?

Best regards, Reinhard

It's _StringAddComma:

#include <string.au3>

$value = 12345.67890
ConsoleWrite("Debug: " & _StringAddComma(stringformat("%.2f", $value)) & @LF)

[Paulie]

You Can try this...

#include <String.au3>

$Test = 123456789.9876
$Dec = StringRegExp($Test, "\.\d*",1)
$Test = StringRegExpReplace($Test,"\.\d*","")
$Test=StringRegExpReplace(_StringReverse($Test), "\d{3}", "\0,")
$Result=_StringReverse($Test)&$Dec[0]
If StringLeft($Result,1) = "," then $Result = StringTrimLeft($Result,1)
MsgBox(0,"",$Result)

Edited January 28, 2008 by Paulie

[ReFran]

Great!

Both works perfectly.

Thanks, Reinhard