• Number patterns
• • Elements of a pattern
  • • Location of elements
    • Numerical elements
    • Static elements
  • Defining a pattern
  • • In the mapping window
    • In an expression
  • Subpatterns

Number patterns

This page explains how to define a pattern to output a certain number in a certain way. You specify the pattern according to the rules and elements specified below.

You can specify custom number patterns in the formatNumber functions, or in the custom number option as described on this page:

Elements of a pattern

A pattern consists of numerical elements and, optionally, static elements. Numerical elements represent a digit, a currency sign, a percentage, a decimal separator etc. Static elements are parts you can include yourself, such as words.

Location of elements

Some elements can only be used in a specific location inside the pattern. Here are the locations:

• Prefix - everything that comes before the number
• Number - the number itself
• Suffix - everything that comes after the number

For instance, in '€12' the euro sign is the prefix. In '12 dollars', dollars is the suffix.

Numerical elements

Static elements

You can use both symbols and letters as static elements. You can use the following symbols by putting them directly in the pattern:

/ * - + & ! ( ) { } [ ] , . ; : < > _ - # @

If you want to use a ' (apostrophe), you need to put 2 of them, like this:

''

If you want to use letters, you need to put them in between apostrophes, like this:

'a'  'dollars'  'a fistful of dollars'

Defining a pattern

In the mapping window

When you have a number in a field, or as the output of an expression, you can use the custom number option in the Format tab of the mapping window to specify a pattern:

In an expression

Defining a pattern in an expression is necessary for the formatNumber and formatNumberR functions:

formatNumber(512.4568,'##.##')formatNumber(512.4568,'000,000.000')

As always with expressions, you need to put strings (such as a number pattern) in between ' ' (apostrophes). This, however, makes it a bit harder to use letters in your patterns, as you can't simply use apostrophes, since those are used to delineate the beginning and ending of the pattern in an expression.

To remedy this, you can escape your apostrophes by putting a \ (backslash) in front of them. So, instead of...

## 'dollars' 

...you type this:

## \'dollars\' 

It may look a bit strange, but it will definitely get the job done. Here's an example of the above pattern: Notice the apostrophe before and after the entire pattern:

formatNumber(512,'## \'dollars\'')

Subpatterns

A pattern can consist of 2 subpatterns: one for the positive representation and one for the negative representation.

The negative subpattern is optional. If you don't include it, the localized minus sign (usually - ) is used in front of the positive representation to represent negative numbers.

Specifyin a negative subpattern is done after putting a ; following the positive subpattern. If there is an explicit negative subpattern, it serves only to specify the negative prefix and suffix. The number of digits, minimal digits, and other characteristics are all the same as the positive pattern. That means that "#,##0.0#;#" produces precisely the same behavior as "#,##0.0#;#,##0.0#".

For instance, '##.##;°' will output °30.33 (for a value of -30.33).