Format Number
Use this data converter in Robots to format a number. The input text must be a number in standard numeric format, such as 12378.64.
Use the Extract Number data converter with the Format Number converter.
To view variables and other elements, see State Pane and Data State Pane.
Properties
Numbers and the letter "E" (both upper and lower case) are not valid in the Decimal Separator, Thousands Separator, and Minus boxes.
- Pattern
-
Configure the pattern of the number. Select from the Default Patterns list or select Calculated and click the box to enter your own in the Expressions editor.
In a pattern, the "." character is always the decimal separator, regardless of what is in the Decimal Separator box. When the number is formatted, the "." character is replaced by the character in the Decimal Separator box. The same applies to the Thousands Separator and Minus boxes.
- Decimal Separator
-
Use the default or specify the separator to use in the number. The separator is placed between the integer and fraction part of the number, for example "." or ",".
- Thousands Separator
-
Use the default or specify the separator to use in the number. This separates groups of thousands in the integer part of the number, for example "," or a space.
- Minus
-
Use the default "-" or specify the character.
Patterns
Patterns provide a flexible way to customize the number formats using the following characters.
|
Character |
Description |
|---|---|
|
0 |
A digit. |
|
# |
A digit, but zero is not shown. |
|
. |
The decimal separator. (The character specified in the Decimal Separator box.) |
|
, |
The thousands separator. (The character specified in the Thousands Separator box.) |
|
- |
The minus sign. (The character specified in the Minus box.) |
|
E |
In scientific notations, separates the mantissa and the exponent. |
If you want, specify separate patterns for positive and negative numbers. Specify the two patterns and separate them with a semicolon (";"). For example, the pattern #,##0.00;(#,##0.00) can be used if negative numbers should be parenthesized instead of the default, where typically the minus sign is placed in front of negative numbers.