Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index



Formatting Numbers

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Formatting Numbers

Basic Information

To learn more about how and where you can use formatting, see the Using Formatting section.

Formatting Numbers

This format is used for formatting digits.

Format string example: math ###-#0,00

  • "-" - means a symbol used to separate groups;
  • "," - means a symbol used to separate decimal part;
  • Number of "#" means the number of digits in a group;
  • Number of "0" means the number of digits after and before decimal. You can use "*" to view all digits after decimal.
  • If you specify |NO_ZERO| in the format text box, and the output value is a zero, no value will be shown.

Examples:

Test StringFormat StringResult
1234567,89math ###'#0.001'234'567.89
1234567,89math ### #0.01 234 567.9
1234567,89math $###,#0$1,234,568
1234567,89math #0,00 EUR1234567,89 EUR
1,2math #00,0001,20
1,2math #000,00001,20
0math #0|NO_ZERO| 

Boolean Format

This format is used for formatting Boolean values (the values that can only be true or false). False means an empty string or 0, true means any string or number other than zero.

Format string example: bool TrueText/FalseText

  • TrueText will be printed if the value is true
  • FalseText will be printed if the value is false.

Examples:

Test StringFormat StringResult
"1"bool Yes/No"Yes"
"0"bool Yes/No"No"
"230"bool Yes/No"Yes"
""bool Yes/No"No"
"false"bool Yes/""
"Hello World"bool Text"Text"
""bool Text""



All topics in the "Formatting Data" section: