Symptoms

The number value can be present in different formats based on the normalization settings specified in the field properties. For example, the comma can be used as a field separator for the decimal part of numbers:

However, after exporting the extracted data to XML, the data format differs from the one specified in the normalization setting, e.g. the comma in numbers is not preserved and is substituted with the dot:

Cause

The comma is not preserved as a decimal separator in the output XML since it is prohibited according to the standards of the number values in the XML format where the decimal digits are always separated by the period (dot):

3.2.3.1 Lexical representation

Decimal has a lexical representation consisting of a finite-length sequence of decimal digits (#x30-#x39) separated by a period as a decimal indicator. An optional leading sign is allowed. If the sign is omitted, "+" is assumed. Leading and trailing zeroes are optional. If the fractional part is zero, the period and following zero(es) can be omitted. For example: -1.23, 12678967.543233, +100000.00, 210.

Resolution

If a comma is necessary to be preserved when exporting to XML, another Data type of the field has to be selected. For example, the field Data type can be changed to Text. The Text type allows almost all the characters to be preserved.

The following screenshot shows the distinction between the output results based on the different field Data types used: