KB Article #69789

Problem with conversion of real numbers when they end up with a "0"

Problem

-- Map failes to parse input with real numbers
-- Tailing zero after decimal is getting truncated while reading input file at map-stage resulting in error
[CNV - 9023]: Scale part is not full filled (1), defined length is 2


Resolution

-- Reason for Error:
* The problem is that when padding character (used also for trimming) is set to "0", this Instruct the parser to remove that character from the input data.
* As a result validation is done for 000.3 instead of 000.30 thus resulting in error.



-- Correction:
In BDoc defination change the Leaf type to customNumeric and set the padding character to " "   (SPACE).