Format Numbers


Synopsis

Reformats all numerical attributes according to the specified settings and change the attributes to nominal.


Description

This operator tries to parse numerical values and formats them in the specified number format. It also supports different kinds of numbers, including integers (123), fixed-point numbers (123.4), scientific notation (1.23E4), percentages (12%), and currency amounts ($123). The format type parameter specifies the basic format, in all cases but for "pattern" the specified locale will be used. In case of pattern the locale is ignored and the specified pattern is used instead.

Please note that this operator only works on numerical attributes and the result will be in any case a nominal attribute no matter if the resulting format would again be a parsable number.

In case of the pattern format type, a pattern parameter is used to define the format. If two different formats for positive and negative numbers should be used, those formats can be defined by a separating ';'. The pattern must have the following structure: pattern := subpattern{;subpattern} subpattern := {prefix}integer{.fraction}{suffix} prefix := any character combination including white space suffix := any character combination including white space integer := '#'* '0'* '0' fraction := '0'* '#'*

The following placeholders can be used within the pattern parameter: 0   a digit

  1.   a digit, zero shows as absent
.   placeholder for decimal separator ,   placeholder for grouping separator. E   separates mantissa and exponent for exponential formats. -   default negative prefix. %   multiply by 100 and show as percentage X   any other characters can be used in the prefix or suffix '   used to quote special characters in a prefix or suffix.


Input


Output


Parameters


ExampleProcess