StringFormat

[anixon]

Using this code:

$Value = StringFormat('%.2f', 0.00)

FileWriteLine($File, $Value)

$Value = StringFormat('%.2f', 10.00)

FileWriteLine($File, $Value)

This is achieved

0.00

10.00

What is the magic to format the numbers to appear in correct column format

Ant..

Edited August 19, 2009 by anixon

[Bowmore]

Using this code:

$Value = StringFormat('%.2f', 0.00)

FileWriteLine($File, $Value)

$Value = StringFormat('%.2f', 10.00)

FileWriteLine($File, $Value)

This is achieved

0.00

10.00

What is the magic to format the numbers to appear in correct column format

Ant..

Try this, although it will only really give you what you want with a mono spaced font

$Value = StringFormat('%.2f', 0.00)
FileWriteLine($File, $Value)
$Value = StringFormat('%.2f', 10.00)
FileWriteLine($File, $Value)

[anixon]

Try this, although it will only really give you what you want with a mono spaced font

$Value = StringFormat('%.2f', 0.00)
FileWriteLine($File, $Value)
$Value = StringFormat('%.2f', 10.00)
FileWriteLine($File, $Value)

I am using the same code as per your example so I guess the question is what is a typical mono font. I am currently using

Global $Font = "times new roman", $FontSize = 10, $FontWeight = 400

Ant..

[Bowmore]

I am using the same code as per your example so I guess the question is what is a typical mono font. I am currently using

Global $Font = "times new roman", $FontSize = 10, $FontWeight = 400

Ant..

Sorry I posted the wrong code in my first reply.

$Value = StringFormat('%6.2f', 0.00)
FileWriteLine($File, $Value)
$Value = StringFormat('%6.2f', 10.00)
FileWriteLine($File, $Value)

[anixon]

Sorry I posted the wrong code in my first reply.

$Value = StringFormat('%6.2f', 0.00)
FileWriteLine($File, $Value)
$Value = StringFormat('%6.2f', 10.00)
FileWriteLine($File, $Value)

What does the 6 actually do in '%6.2f' as it does appear to have an explaination within the documentation. I noticed that 0 as a flag can be used as width padding.

Ant..

[Malkey]

What does the 6 actually do in '%6.2f' as it does appear to have an explaination within the documentation. I noticed that 0 as a flag can be used as width padding.

Ant..

The "6" is the total number of characters.

;
$Value = StringFormat('%6.2f', 0.00)
ConsoleWrite($Value & " <== 6 characters in total" & @CRLF)

$Value = StringFormat('%6.2f', 123.56)
ConsoleWrite($Value & " <== 6 characters in total" & @CRLF)

$Value = StringFormat('%7.2f', 123.56)
ConsoleWrite($Value & " <== 7 characters in total (1st character a space)" & @CRLF)
;

[anixon]

The "6" is the total number of characters.

;
$Value = StringFormat('%6.2f', 0.00)
ConsoleWrite($Value & " <== 6 characters in total" & @CRLF)

$Value = StringFormat('%6.2f', 123.56)
ConsoleWrite($Value & " <== 6 characters in total" & @CRLF)

$Value = StringFormat('%7.2f', 123.56)
ConsoleWrite($Value & " <== 7 characters in total (1st character a space)" & @CRLF)
;

Ahhh that makes sense to ensure the correct justification you just increase the number to accommodate thousands, 10's of thousands etc. So much to learn so little time. Appreciate your explaination Ant.. an AusVicMex