Managed File Transfer User Guide

10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Number Patterns

Number patterns are used to format how numbers are displayed. The characters specified in the table below are interpreted as patterns representing the components of a number string. A number pattern can be prefixed or suffixed by text or other special characters using single quotes. Characters that are not interpreted are copied into the output string during formatting or matched against the input string during parsing.

The following pattern letters are defined:

Symbol	Description
0	Placeholder for a digit. If more placeholders are specified than the value returned, zeros are displayed in those positions.
#	Placeholder for a digit. If more placeholders are specified than the value returned, nothing is displayed in those positions.
'	Single quotes can be wrapped around text and symbols before or after a number pattern.
.	Placeholder for decimal separator
,	Placeholder for grouping separator
E	Separates the significant digits from the exponent in scientific notation
-	Default negative prefix
$	Currency sign
%	Percent sign

Rename Saved Search

Table of Contents

Managed File Transfer User Guide

Managed File Transfer User Guide

Number Patterns

Number Patterns