Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excerpt
hiddentrue

format(formatString, arg1, ..., argN) Formats a string according to a template format and supplied arguments.

Function: format()

Formats a string according to a template format and supplied arguments.

...

format(formatString, arg1, ..., argN)

ArgumentTypeDescription
formatString
href="#formatString">Format
Format StringA string defining the format of the result. (
href="#formatString">Format
Format String Syntax)
arg1..NAnyAny number of arguments to be placed into formatString

Examples

format("%10.3f", in.callTotal)

...

The formatString can also contain fixed plain text string elements  elements as in this case which returns, with in.callTotal = 25.33256:
"Value to 3 decimal places is:     25.333, or rounded to a whole number and padded with zeroes is: 0000000025"

...

The following basic format specifiers are available:

  • %s – - string
  • %t – - date/time
  • %f – - floating point number
  • (see below for more details and other types available)

...

Each component of this format specifier is described below:

argument_index

This optional value specifies which of the supplied arguments provided to replace into the format string. This is useful when the same data is used several times, in a single format string - possibly, formatted differently in each case.

format("Value to 3 decimal places is: %1$10.3f, or rounded to a whole number and padded with zeroes is: %1$010.0f", in.callTotal)
with in.callTotal = 25.33256, returns "Value to 3 decimal places is:     25.333, or rounded to a whole number and padded with zeroes is: 0000000025"

flags

For all data types:

  • ‘'-' - ’ – left justify

For numeric types:

  • ‘'+’ – ' - always include a sign
  • ‘ ’ – ' ' - include a leading space for positive values
  • ‘0’ – '0' - pad with zeroes
  • ‘',’ – ' - use local specified grouping operators, e.g. a comma rather than a point for a decimal separator in France
  • ‘'(’ – ' - put negative numbers in brackets, .e.g. for ledger reports

width & precision

The width is an optional parameter which specifies the minimum number of characters written to the output.
The precision is an optional parameter which specifies the maximum number of characters written to the output.
For data types 'e', 'E', and 'f' the precision is the number of digits after the decimal separator. For data types 'g' or 'G' the precision is the total number of digits in the resulting magnitude after rounding.
format("%10.3f", in.callTotal)
gives the output: "     2.718"

Data type

  • 's' – - string
  • 'd' – - integer
  • 'e' – - floating point number; the output is formatted as a decimal number in computerized scientific notation
  • 'f' – - floating point number
  • 'g' – - floating point number; the output is formatted using computerized scientific notation or decimal format, depending on the precision and the value after rounding
  • 't' – - date/time
  • '%' – - percent; gives a literal ‘%’ '%' sign in the output

See Also

...