CSV Output Files and XML Output Files

Numeric items (attribute V) with a sign (S in the sign column) have "+" or "-" placed at the beginning of the item, depending on the sign of the input item.

CSV Input Files and XML Input Files

Data Converter checks for "+" and "-" signs at the beginning and end of the field, and sets the sign of the output number accordingly.  If there is no sign character, the output is set to "+".

Values Output when Numeric Errors are Detected

Numeric errors occur when input numeric items contain invalid values.

When the output numeric field contains characters (types Z and V), Data Converter will read the lower 4 bits and output a decimal digit based on that value (mod 10) (i.e. the remainder when the value is divided by 10).   For example, if the input field contains A (0x41), the output is the digit 1; if the input is L (0x4c), the output digit is 2 (0xC divided by ten leaves a remainder of 2).

For all other output numeric types, Data Converter outputs zero when the input data is invalid.

Digit Size Errors

Data Converter reports digit size errors if there are insufficient digits in the integer part of the output number to keep the digits from the input number.